Forum Discussion
Same Day previous Year
- Anonymous1 year ago
Hi NewbieJono
Thanks for the reply from Greg_Deckler .
The following testing is for your reference.
Sample:
Create two measures as follow
This year = CALCULATE(SUM('FACT -Receipts'[Value]) , FILTER('FACT -Receipts', [Date] >= MIN('DIM - Date Table'[Date]) && [Date] <= MAX('DIM - Date Table'[Date])))Same Day previous Year = CALCULATE ( SUM ( 'FACT -Receipts'[Value] ), FILTER ( 'FACT -Receipts', [Date] >= DATE ( YEAR ( MIN ( 'DIM - Date Table'[Date] ) ) - 1, MONTH ( MIN ( 'DIM - Date Table'[Date] ) ), DAY ( MIN ( 'DIM - Date Table'[Date] ) ) ) && [Date] <= DATE ( YEAR ( MAX ( 'DIM - Date Table'[Date] ) ) - 1, MONTH ( MAX ( 'DIM - Date Table'[Date] ) ), DAY ( MAX ( 'DIM - Date Table'[Date] ) ) ) ) )Output:
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
NewbieJono First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8