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
T_H
Frequent Visitor

Returning month over month difference in a matrix with a column value (% of column)

I'm new to Power BI and I have created a report that is reporting information as expected and I'm struggling with how to compare the difference.
The column is a count distinct with Percentage of column total. The goal of the Delta colum is to be the difference between month X and the prior month. In my research it's not a month over month comparison since each row is the percentage of column in the matrix (rather than coming from a column in the dataset). Any ideas?

T_H_0-1646861295224.png

 

4 REPLIES 4
Ashish_Mathur
Super User
Super User

Hi,

Please show the expected result.


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

Sure Ashish, I broke it down in Excel since I'm not able to in Power BI.
My Delta column would be current month subtracted by prior month.

T_H_0-1646921349396.png

 

Hi,

Share the download link of your PBI file.


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

Hi, due to the nature of the data I'm not permitted to share. Is there anything specific that I could share other than the PBIX?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.