Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have a set of data with a Year-Week column.
I want to create a couple of measures for This Year QUS and Last Year QUS so I can see the year on year variance.
So effectively it will show Year-Week 2018-50 as one measure and 2017-50 as another.
Also, when I have a slicer with the Year-Weeks in if I selected 2018-49 it would then show 2017-49.
If I had a date column I could use SAMEPERIODLASTYEAR but unfortunately I don't
Solved! Go to Solution.
Hi @Anonymous
You may create the Year column and Week column. Then you may get the last year QUS as below.
LastYearQUS = CALCULATE ( [QUS], FILTER ( ALL ( Table ), Table[Year] = SELECTEDVALUE ( Table[Year] ) - 1 && Table[Week] = SELECTEDVALUE ( Table[Week] ) ) )
Regards,
Cherie
Hi @Anonymous
You may create the Year column and Week column. Then you may get the last year QUS as below.
LastYearQUS = CALCULATE ( [QUS], FILTER ( ALL ( Table ), Table[Year] = SELECTEDVALUE ( Table[Year] ) - 1 && Table[Week] = SELECTEDVALUE ( Table[Week] ) ) )
Regards,
Cherie
Hi @Anonymous
I would suggest you create a new thread on forum so that more community members can see it and provide advice. Please remember to post dummy data and desired result.
Regards,
Cherie
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
109 | |
108 | |
93 | |
61 |
User | Count |
---|---|
171 | |
139 | |
133 | |
102 | |
86 |