Power BI | Writing DAX Formula To Fill a Blank Measure with Previous Non Blank Value
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
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]
Thanks a lot. Nice solution
Thank you! You saved my day!
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...