Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

Compare same category previous month

Hello good day community, currently I have a problem I want to bring the data of the previous month to a new column, so that it is as follows

Category || Current month || Previous month

============================

Category1 || Data January || Fact December

Category1 || Fact February || Fact January

Category2 || Data January || Fact December

Category2 || Fact February || Fact January

I'm currently trying to

CALCULATE([Price x ml unit], DATEADD(BD[Date],-1, MONTH))
and also with
CALCULATE([Price x ml unit], prviousmonth(BD[Date]))
However even if you run the field does not return me any results, could you help me please?
Thank you.

1 Reply

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    5 years ago

     

    Hi Syndicate_Admin ,


    Which connection mode is your data source and is it dynamically updated? Can you provide more detailed information and data model for me to do further testing?


    Let me know immediately, looking forward to your reply.


    Best Regards,
    Henry


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