Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
My raw data doesn't always have values for every month. So when displaying in a matrix format i'm getting "blank" data for months that are missing. How can i build my measure so that if the data is blank for a given month it pulls in the value from the last month with a value. For example Jun-21 is blank but i need to go back to Apr-21 to get a number.
Thanks in advance for the help!
Solved! Go to Solution.
Assuming you have a date table the measure would be along these lines
Measure =
VAR _Date = MAX('Dates'[Date])
RETURN
CALCULATE(
LASTNONBLANKVALUE( Dates[Date], SUM ( 'Table'[Amount] ) )
,Dates[Date] <= _Date
)
Hi,
See if my solution here helps - Show Balance outstanding everyday even if data for everyday is not available.
Assuming you have a date table the measure would be along these lines
Measure =
VAR _Date = MAX('Dates'[Date])
RETURN
CALCULATE(
LASTNONBLANKVALUE( Dates[Date], SUM ( 'Table'[Amount] ) )
,Dates[Date] <= _Date
)
works great! thx for the help!
User | Count |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
96 | |
94 | |
92 | |
78 | |
71 |