month over month Change

Hi,

I have a difficult one I am trying to figure out.

I have a table that is pull from a sharepoint list. I have a column with two values let's say X and Y and a card displaying the % of X.

How can I display a month to month %change of the X value? Can I create a 30 days counter or something? for example on Day1 Result 1 = Count X. And after 30 Days Monthly Change = Count X / Result 1?

Thanks,

Need Help

Anonymous
9 years ago
HI abukapsoun,

If you want to compare with current month and previous month, you can refer to below link:

Calculate difference from previous month

If above not help, please share some sample data to analysis.

Regards,

Xiaoxin Sheng

8 Replies

Abduvali
Skilled Sharer
9 years ago
HI abukapsoun,

Try available option from Quick Measures:

Hope it helps, have fun.

Regards
Abduvali
- CaroGonzalez
  Microsoft Employee
  3 years ago
  I can't see this list of quick measure. My list is very basic/short.
  What do I need to do?
Anonymous
Not applicable
9 years ago
HI abukapsoun,

If you want to compare with current month and previous month, you can refer to below link:

Calculate difference from previous month

If above not help, please share some sample data to analysis.

Regards,

Xiaoxin Sheng
- Anonymous
  Not applicable
  5 years ago
  Hi All,
  
  I am trying to find the Month on month change fo rbelow shown projects
  Using the quick mesure Month on month change :
  
  uses below Matrix strcture :
  
  But the mesure returned
  
  Could you kindly help me out here?
  
  Respectfully,
  
  Jithesh Chathoth.
  - Ashish_Mathur
    Super User
    5 years ago
    Hi,
    
    Share the link from where i can download your PBI file.
sherie00
New Member
8 years ago
Hi, I am a new user to PBI. Can anyone help me. I have a column called "Month on month change" displaying the difference between the each month and its prior month value. I can't seem to be able to get the YTD difference which should be 166.