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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
jaimin_patel
New Member

Periodic % change in value

Hi All,

 

I am unable to derive % change of Row level value from its previous period value using DAX.

 

jaimin_patel_0-1602675496444.png

"Disbursement Amt" is calculated using a DAX measure in itself which is agregated at 'Quarter Ref No'.

"Quarter Ref No" is a numeric value which is assigned to Quarters present in the data file.

2 REPLIES 2
Anonymous
Not applicable

Not clear. Please have a look at DAX time-intel patterns (which is exactly what you want): https://www.daxpatterns.com/standard-time-related-calculations/

Hi,

I want to calculate Quarter on Quarter % change based on the Reference numeric value which is given to the quarters present in the data sheet. Each Reference number belongs to quarter in chronological order.

Unable to get result using reference number in DAX which should be dynamic in nature.

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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