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

[Anonymous]

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?

[amitchandak]

@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

[Anonymous]

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?

[Anonymous]

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 

[Anonymous]

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?

[Anonymous]

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 

[Anonymous]

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.

[Anonymous · Accepted solution]

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