Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
abukapsoun
Post Patron
Post Patron

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,

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

8 REPLIES 8
sherie00
New Member

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.

 

IMG_6134.JPG

v-shex-msft
Community Support
Community Support

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
Not applicable

Hi All,

 

I am trying to find the Month on month change fo rbelow shown projects

MONTHLYJPG.JPG

Using the quick mesure Month on month change :

 

messure.JPG

uses below Matrix strcture :

 

viz.JPG

 

But the mesure returned 

 

MoM.JPG

Could you kindly help me out here?

 

Respectfully,

 

Jithesh Chathoth.

Anonymous
Not applicable

That is not a file download link.


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

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
Skilled Sharer
Skilled Sharer

HI @abukapsoun,

 

Try available option from Quick Measures:

Untitled.png

 

Hope it helps, have fun.

 

Regards

Abduvali

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

What do I need to do?

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.