Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I really stuck here to fill in the gap. I failed to use LASTNONBLANKVALUE, Please help!!
Solved! Go to Solution.
HI @Anonymous ,
Test the below to create a new column:
newaverage =
IF (
'Table'[average] = BLANK (),
CALCULATE (
MAX ( 'Table'[average] ),
FILTER (
ALL ( 'Table' ),
'Table'[average] <> BLANK ()
&& 'Table'[Date] >= EARLIER ( 'Table'[Date] )
)
),
'Table'[average]
)
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
HI @Anonymous ,
Test the below to create a new column:
newaverage =
IF (
'Table'[average] = BLANK (),
CALCULATE (
MAX ( 'Table'[average] ),
FILTER (
ALL ( 'Table' ),
'Table'[average] <> BLANK ()
&& 'Table'[Date] >= EARLIER ( 'Table'[Date] )
)
),
'Table'[average]
)
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
I just checked your result, there is a bug need to debug.
Hi @Anonymous ,
Thank you for pointing this out, I have made the adjustment, see below:
newaverage =
VAR MAXDATE =
CALCULATE (
MIN ( 'Table'[Date] ),
FILTER (
ALL ( 'Table' ),
'Table'[average] <> BLANK ()
&& 'Table'[Date] >= EARLIER ( 'Table'[Date] )
)
)
RETURN
CALCULATE (
MAX ( 'Table'[average] ),
FILTER ( ALL ( 'Table' ), 'Table'[Date] = MAXDATE )
)
Best Regards
Lucien
Hi babyjb123
You have given very little infomation. Please give detailed infomation when postng question on the forum. Thank you. Have you tried using Fill down in the columns in the query editor?
🙁
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
96 | |
75 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |