How to calculate latest 30 days sales amount in dax

[Pratima]

Hi All,

How to calculate latest 30 days sales amount in dax. can anyone please help me the same asap.

Thanks,

Pratima 

[v-xjiin-msft]

Hi @Pratima,

Generally, you can try this measure:

Last 30 days =
CALCULATE (
    SUM ( Table2[val] ),
    FILTER (
        ALL ( Table2 ),
        Table2[date]
            >= MAX ( Table2[date] ) - 30
            && Table2[date] <= MAX ( Table2[date] )
    )
)

If it doesn't satisfy your requirement, please share us more detaile information like some sample data and its corresponding desired result. So that we can know the right direction.

Thanks,
Xi Jin.