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 want to show previous 12 "periods" based on slicer selections. So, for example if I select "Period" = 9 and "Year" = 2020 I want it to show me 2019 P9, 2019 P10, 2019 P11, 2019 P12, 2020 P1, 2020 P2, 2020 P3, 2020 P4, 2020 P5, 2020 P6, 2020 P7, 2020 P8.
What's the best way to implent this?
@DomA001 , Ideally these Period P1 , p2 should p01 and p02 .
Then you can have rank on YYYYPP - 2020P01 And have separate period year table
Period Rank = RANKX(all('Date'),'Date'[Year Period ],,ASC,Dense)
This Period = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Period Rank]=max('Date'[Period Rank])))
Last Period = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Period Rank]=max('Date'[Period Rank])-1))
Last year Period = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Period Rank]=(max('Date'[Period Rank]) -12)))
last 12 month = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Period Rank]>=(max('Date'[Period Rank]) -12) && 'Date'[Period Rank]<=max('Date'[Period Rank])))
But this might group the things together, refer thsi video for the approch
https://www.youtube.com/watch?v=duMSovyosXE
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |