Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Month on Month

Hello,

I am trying to show users month on month differences for user in my main data table.

I used this dax code

Last Month main user = CALCULATE(SUM('main data'[Users]),PARALLELPERIOD('Calendar'[Month],-1, MONTH))
But it does not work.
 
Can someone take a look at the sample file and please tell me what I am doing wrong.

https://drive.google.com/file/d/1th97AOfqMzCjrihDIUISZS6XuT4bJJMX/view?usp=sharing

 

Also is it possible to show the current month and last month percentage change in card? What formula would I need to do that ?

 

Thanks

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Anonymous The biggest problem you have is that your main data table just has a single column with no relation to your Calendar table. So, not sure how you expect to know which users are for which months.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Greg_Deckler 

     

    Thank you for your feedback

    Please see the PBI file which now has a relationship from calendar table to main data but the month on month

    https://drive.google.com/file/d/1G2nE_quaVIK0ti96KzK4465GFkKM7RI9/view?usp=share_link

    change still does not work.

     

    Is there a way to get the month on month to display on a line chart or bar chart or histogram to show the month on month change, also in percentage.

     

    Can the month on month change also been shown in a card (% change)

     

    Thank you in advance for your help