Get the measure for previous date and current date to get trend

[jeffrock]

Hi Team, I m trying to automate a report for daily analysis.

I have some precalculated measure that works on the date slicer, based on the date slicer it gives the number.

I need to find the trend with what happened yesterday and the previous day

so when I select only yesterday's date it should give me yesterday's result as well as a day before yesterday's result to check the anomalies.

I want these 2 results such that I can plot them in a graph to see the trend and differences based on different projects.

some sample for measure which I m using

fullfilled_task (in %) = sum(actual tasks)-sum(outofplantask)/sum(total_task)

distance = sum(distance covered)

and so on

any suggestions would be helpful

Thank you

[amitchandak · Accepted solution]

@jeffrock , with help from the date table and time intelligence

Last Day = CALCULATE([Measure], FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])-1))
Last Day = CALCULATE([Measure], previousday('Date'[Date]))

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...