Solved: month over month Change

abukapsoun · ‎09-14-2017

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,

v-shex-msft · ‎09-15-2017

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

sherie00 · ‎07-06-2018

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.

v-shex-msft · ‎09-15-2017

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Anonymous · ‎10-21-2020

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.

Anonymous · ‎10-21-2020

Hi Ashish,

Please find the link to the report.

https://app.powerbi.com/groups/me/reports/318ac940-ea3a-4755-b722-c3a22035d14f?ctid=81169af2-4fb4-48...

Ashish_Mathur · ‎10-22-2020

That is not a file download link.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Ashish_Mathur · ‎10-21-2020

Hi,

Share the link from where i can download your PBI file.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Abduvali · ‎09-14-2017

HI @abukapsoun,

Try available option from Quick Measures:

Hope it helps, have fun.

Regards

Abduvali

CaroGonzalez · ‎01-25-2023

I can't see this list of quick measure. My list is very basic/short.

What do I need to do?

month over month Change

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly