PowerBI DAX Previous Day query

[mukhan311]

Hi all,

I am working on a report that refreshes automatically daily. I have an opportunity column and I want to understand the change in opportunity amount and list out all the opportunity changes from previous day. 

How can I get this done. 

Thank you all in advance.

Regards,

Mubashshir Khan

[Ritaf1983 · Accepted solution]

Hi @mukhan311 
If I understand correctly, you're referring to a scenario where data resets daily without any record of the previous day's values. In this case, please review my response in the linked discussion:

https://community.fabric.microsoft.com/t5/Desktop/Monitoring-workload/m-p/3868072#M1246230

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[mukhan311]

Yes, Exactly, there is no record of the previous day's data, it refreshes and then the previous day's data is lost. 
I'll go through the link and figure out if the solution can be implemented. 
thank you.

[v-kaiyue-msft]

Hi @mukhan311 ,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.