Power BI | Writing DAX Formula To Fill a Blank Measure with Previous Non Blank Value

Sdílet
Vložit
  • čas přidán 30. 07. 2024
  • This video explains how to write the DAX formula to Fill a Blank Measure with its preceding non-blank value based on the Dates.
    #PowerBI #AllthingsPowerBIWithAdebola
  • Věda a technologie

Komentáře • 4

  • @matthewpage4706
    @matthewpage4706 Před 4 měsíci

    Thank you. Very helpful
    Here's the DAX for anyone who wants to cut & Paste
    Order Amount Blanks Fill From Previous =
    var vLatestNonBlankDate =
    CALCULATE( MAX('Date'[Date]),
    FILTER(ALL('Order Amount'),
    'Order Amount'[Date]

  • @user-ic4mm1gq1c
    @user-ic4mm1gq1c Před 8 měsíci

    Thanks a lot. Nice solution

  • @otavioalves813
    @otavioalves813 Před 2 lety

    Thank you! You saved my day!

  • @marieleporini5446
    @marieleporini5446 Před 8 měsíci

    What if one of my order is 0 and I want this value (0) to be fill down as well? Since we have the filter [Amount] 0 then it is not taking these 0 values into account...