20 How to Use ISAFTER, ISONORAFTER, ISBLANK & ISEMPTY in DAX | DAX in Power BI

Sdílet
Vložit
  • čas přidán 8. 11. 2022
  • Chapter 20 discusses ISAFTER, ISONORAFTER, ISBLANK and ISEMPTY functions in DAX using Power BI.
    This video has information on How to deal with ISAFTER, ISONORAFTER, ISBLANK & ISEMPTY functions in DAX.
    1. Introduction about 4 functions
    2. How to use these functions
    3. When to use these functions
    ------------------------------------------------------------------------------------------
    To find more details, click the below link
    GitHub (DAX - Chapter 20) : github.com/arpitag1/Power-BI
    -----------------------------------------------------------------------------------------
    Medium: / arpita-ghosh
    LinkedIn: / arpita19sep
    -----------------------------------------------------------------------------------------------------------
    This channel is created to prepare tutorial videos on different technologies like Python, R language, Power BI, Tableau, SQL, Excel, Google Data Studio, etc.
    #dataanalysis #dax #powerbi #powerbicourse #powerbidesktop #powerbitutorial
  • Věda a technologie

Komentáře • 14

  • @ArpitasTechCorner
    @ArpitasTechCorner  Před rokem +2

    One Correction: Please create a calculated column instead of a calculated measure for the below field and select the sum from the summarization drop-down.
    Total Price_3 = IF(ISBLANK(price_table[Total Price_2]),1000,[Total Price_1]+100).
    I have uploaded the latest code to GitHub.

    • @ItsFun_2Trip
      @ItsFun_2Trip Před 11 měsíci

      Mam Please tell me why we cannot create measure there? And when I created measure for price_3 why i was getting 4 rows?? It would be great if you could explain why we are not using measure ? Thanks in advance!

  • @GabrielOcheGodwin
    @GabrielOcheGodwin Před rokem +1

    Great explanation. Please zoom in next time for more clarity

    • @ArpitasTechCorner
      @ArpitasTechCorner  Před rokem

      Thank you. I will try. However, please check the description section to download the working file for your reference.

  • @sreemalapal
    @sreemalapal Před rokem

    Thanks for this explanation

  • @ItsFun_2Trip
    @ItsFun_2Trip Před 11 měsíci +1

    Started on 23 July 2023 - Completed on 23 July 2023. Thanks Arpita Mam for this Complete Dax Videos Series of 30 videos cretaed by you!!!!!!!!☺☺🤩🤩

  • @jaldaamol46
    @jaldaamol46 Před rokem

    Thanks for posting this video, Mam.

  • @frankgovers8420
    @frankgovers8420 Před rokem

    Have you checked the totals?

    • @ArpitasTechCorner
      @ArpitasTechCorner  Před rokem

      I am showing here how to use the function. When I will showcase any project, at that time I will demonstrate data validation process.

    • @frankgovers8420
      @frankgovers8420 Před rokem

      @@ArpitasTechCorner , yep, but the totals are wrong

    • @ArpitasTechCorner
      @ArpitasTechCorner  Před rokem

      @Frank Govers Thank you. I have corrected that.