Measure

[TheLegendTamer]

Hi all,

I have two columns in Desktop, one of date and one of a price.

I have created a basic matrix table as attached but I want a DAX/Measure to show the % difference next to it in a new column of the two prices between both dates.

Is this possible?

Thanks

[Anonymous]

@TheLegendTamer,

I make a test in the following sample table and create the calculated columns as below.

Index = CALCULATE(COUNTROWS(Table), FILTER(Table,Table[Date]<=EARLIER(Table[Date]) && Table[CoverType]=EARLIER(Table[CoverType])))

% Difference = var previous=CALCULATE(FIRSTNONBLANK(Table[Value],Table[Value]),FILTER(Table,Table[Index]=EARLIER(Table[Index])-1 && Table[CoverType]=EARLIER(Table[CoverType]) )) return IF(ISBLANK(previous),BLANK(),(Table[Value]-previous)/previous)

If the above DAX don't help, please share sample data of your original table.

Regards,
Lydia

[TheLegendTamer]

Hi,

Thanks for the reply.

The %Difference column is all blank I'm afraid.

Unable to share table due to most of data in it but thank you anyway.

[Anonymous]

@TheLegendTamer，

You can share me dummy data of your table, and send me the data via Private Message.

Regards,
Lydia