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.
Hi guys,
Solved! Go to Solution.
@mberndt , for all such case you you should have seperate table ITERATION or period and Try like
Assumsing [ITERATION] is column not measure
CALCULATE (
SUM ( NC_FALLOUT_TREND_DATA[FALLOUT_COUNT] ),
FILTER ( 'ITERATION', [ITERATION] = MAX ( [ITERATION] ) )
)
CALCULATE (
SUM ( NC_FALLOUT_TREND_DATA[FALLOUT_COUNT] ),
FILTER (all( 'ITERATION'), [ITERATION] = MAX ( [ITERATION] ) - 1 )
)
similar approach what I use for the week
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
@mberndt , for all such case you you should have seperate table ITERATION or period and Try like
Assumsing [ITERATION] is column not measure
CALCULATE (
SUM ( NC_FALLOUT_TREND_DATA[FALLOUT_COUNT] ),
FILTER ( 'ITERATION', [ITERATION] = MAX ( [ITERATION] ) )
)
CALCULATE (
SUM ( NC_FALLOUT_TREND_DATA[FALLOUT_COUNT] ),
FILTER (all( 'ITERATION'), [ITERATION] = MAX ( [ITERATION] ) - 1 )
)
similar approach what I use for the week
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
@amitchandak Thank you for your reply!
I created a dimension table for Iteration as you mentioned it with Enter data and made the relationship between the two tables. I changed the meassure exactly how you wrote it but still have a problem. Currently it returns the fallout count value of the latest (== max iteration) iteration. So as the result of the substraction I get only the value [t] and not value [t] - value [t-1].
Can you please help? Thank you in advance!
@mberndt , hope for t-1 you are using all in filter like -all( 'ITERATION')
Because if "t" is selected, then you will not get t-1
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@amitchandak I am sorry, it works well right now... Thank you for your quick replies, really appreciated!
User | Count |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |