Periodic % change in value

[jaimin_patel]

Hi All,

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

"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.

[Anonymous]

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/

[jaimin_patel]

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.