DAX: Difference Percentage(Current Week % - Previous Week%)

[harirao]

Hi All,

I want to calculated diffrence % of (Current week- Previous Week). created two new columns i.e Latest Date & Previous week.

[harirao]

Below is the example what i am looking I want to create a new column where i should see the Diffrence %

Product ID "142263-013" for Current wk diffrence is "-15%"(100%-115%) & "142263-013" -63%(100%-163%)

Please note Forecastintegrity% is caluclated column

Regards,

Hari

[v-kelly-msft]

Hi  @harirao ,

Go to query editor>add column>Index column:

Then you can create a calculated column to achieve what you need:

Column = 
var a=CALCULATE(MAX('Table'[Forcastintergity%]),FILTER('Table','Table'[Index]<EARLIER('Table'[Index])&&'Table'[Product ID]=EARLIER('Table'[Product ID])))
Return
IF(a=BLANK(),BLANK(),'Table'[Forcastintergity%]-a)

And you will see:

Or you can create a measure instead:

Measure = 
var a=CALCULATE(MAX('Table'[Forcastintergity%]),FILTER(ALL('Table'),'Table'[Index]<SELECTEDVALUE('Table'[Index])&&'Table'[Product ID]=SELECTEDVALUE('Table'[Product ID])))
Return
IF(a=BLANK(),BLANK(),MAX('Table'[Forcastintergity%])-a)

And you will see:

For the related .pbix file,pls click here.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[harirao]

Thanks for your solution,

Please note: Forecastintegrity% is calculated measure, both solution is not working.

Regards,

Hari

[v-kelly-msft]

Hi  @harirao ,

Sorry I thought Forecastintegrity% is a calculated column,if it's a measure,it'd better first change into  a calculated column,could you pls advise me the dax expression of  Forecastintegrity% if you dont know how to change?

Or if it's possible,could you pls upload your .pbix file to onedrive business and share the link with us?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[harirao]

Hi @v-kelly-msft ,

Please find the below dax used for calculations

When i created column for Forecastintegrity% i was not getting correct result,  I tried doing "Don't Summarize" i was get 100%.

Regards,

Hari

[v-kelly-msft]

Hi @harirao ，

Sorry for the late reply!

I have checked your calculated columns[Test CURP], [Test SFRP]  and your measure [Forecastintegrity%],results under which are right.

So would you pls advise me the logic about the columns with the measure?I need it to modify them.

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[harirao]

Hi @v-kelly-msft,

Can you please help on this calculation?

Regards,
Hari

[parry2k]

@harirao did you referred to the videos I posted earlier, what exactly not working if you watched these videos.

[parry2k]

@harirao there are so many posts on time intelligence here few links

https://www.youtube.com/watch?v=jclWnA7pEvY

https://www.youtube.com/watch?v=jBPLm5BHl2c