topic Can i use a measure to get the previous dates results? in DAX Commands and Tips

Can i use a measure to get the previous dates results?

Anonymous — Mon, 14 Nov 2022 11:10:40 GMT

I am trying to display the percentage change between todays data and yesterdays, i have tried to create a measure that will provide the prevous days data, the measure is also filtering for values less than 30:

Previous_Day = CALCULATE(COUNT('Visit_Rate_History'[LC/O]), FILTER('Visit_Rate_History', 'Visit_Rate_History'[Days Since Last_x002] > 30) = TODAY() - 1)

I am unsure why this doesnt work, any tips?

Re: Can i use a measure to get the previous dates results?

amitchandak — Tue, 15 Nov 2022 02:24:02 GMT

Anonymous , You can try measures like

Today = CALCULATE([Net], FILTER('Date','Date'[Date] = Today() ) )
Yesterday = CALCULATE([Net], FILTER('Date','Date'[Date] = Today()-1 ) )

https://medium.com/chandakamit/cheat-sheet-power-bi-time-intelligence-formulas-using-today-654f26e27304

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

Re: Can i use a measure to get the previous dates results?

Anonymous — Tue, 15 Nov 2022 08:56:51 GMT

Hi Amitchandak, thank you for this!

I also need it to filter the results to only count values under 30? is that possible with that formula?

Re: Can i use a measure to get the previous dates results?

Anonymous — Mon, 21 Nov 2022 09:35:53 GMT

Hi Anonymous ,

The above formula dynamically displays the current day and yesterday's values. If you need to filter the results, you can create a calculated column to calculate the percentages for both days, and then place the calculated column in the filter area for direct filtering.Like the following shows, I filter data under 50%:

Related pbix file you can also refer.

Best regards,

Community Support Team Selina zhu

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

Re: Can i use a measure to get the previous dates results?

Anonymous — Mon, 21 Nov 2022 09:43:42 GMT

Hi,

Thank you for this!

I need to only show the percentage change, would i just need to create a measure that divided today by yesterday and then the Multiply by 100?

Re: Can i use a measure to get the previous dates results?

Anonymous — Mon, 21 Nov 2022 09:47:32 GMT

Hi Anonymous ,

In power bi, there are more convenient options to help you transform the values directly into percentage form. As shown in the figure,in "column tools".

Best regards,

Community Support Team Selina zhu

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

Re: Can i use a measure to get the previous dates results?

Anonymous — Mon, 21 Nov 2022 14:17:27 GMT

Hi,

Sorry for any confusion caused, i need to only show the difference between todays and yesterdays percentage, so for example:

Today: 40%

Yesterday: 37%

Percentage Change: +3%

I just need to display the percentage Change on a card.

Re: Can i use a measure to get the previous dates results?

Anonymous — Wed, 23 Nov 2022 07:11:58 GMT

Hi Anonymous ,

Like this?

Just create a calculated column and subtract yesterday's value from today's value. Please refer to my pbix file.

Best regards,

Community Support Team Selina zhu

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