Same Day previous Year

[NewbieJono]

Hello, I have some Dax to get from the previous year, which seems to work. but for some reason, the total volume is completely wrong, There is a filter of 3 weeks applied to the table

Same Day Previous Year = CALCULATE(sum('FACT -Receipts'[Volume]),dateadd('DIM - Date Table'[Date],-1,YEAR))

[Anonymous · Accepted solution]

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 Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[NewbieJono]

Hello, it seems to be returning blanks? any ideas?

[Greg_Deckler]

@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