Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I hope everyone is having a wonderful Wednesday! My firm uses a 445 calendar, and I am trying to perform YTD, QTD, & MTD calcs on prior years. I am able to return the proper prior year value per date; however, I am having trouble with the time intelligence calcs. Thank you so much for your help!
@AllenStuhr , You have to follow this approach using start date of each period
you need a column based on the start period date or year period in you date table
Period Rank = RANKX(all(Period),Period[year period],,ASC,Dense)
Then measure
This Period = CALCULATE(sum('Table'[Qty]), FILTER(ALL(Period),Period[Period Rank]=max(Period[Period Rank])))
Last Period = CALCULATE(sum('Table'[Qty]), FILTER(ALL(Period),Period[Period Rank]=max(Period[Period Rank])-1))
Power BI Custom Period Till Date (PTD)- https://youtu.be/rQ3Z_LtxwQM
DAX Calendar - Standard Calendar, Non-Standard Calendar, 4-4-4 Calendar
https://www.youtube.com/watch?v=IsfCMzjKTQ0&t=145s
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |