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 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!
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |