Change from previous date total

Power BI
1

Hi all,

I have a table with dates and want to show the difference from the previous day.

For instance in the image below, For instance in the change column, i want to show the previous change from the prior day.

My formula for previous day is

PD =
Var _PD = max(‘Date’[Date]) -1
Return
Calculate(
[Total Prospects],‘Date’[Date]=_PD)

WIP File.zip (10.9 MB)

image
image420×635 19.1 KB

I have also attached a WIP file.

2

Hi @ysherriff, thanks for posting your query! Bumping this post for visibility

3

Hi,

Do you want this kind of output:
image

You just need to do little tweak in your dax :

PD =
Var _PD = max(‘Date’[Date]) -1
Return
Calculate(
[Total Prospects],filter(All(‘Date’),‘Date’[Date]=_PD))

Every thing work fine.

I hope i am able to help you .
Let me know incase it does not solve your purpose.

WIP File.pbix (11.0 MB)

Thanks

1 Like
4

Thank you very much and it is exactly what I am looking foe