Show a visual has changed in the last 24 Hours

[Anonymous]

Hello,

I am trying to have my visuals show if the result of their underlying measures have changed in the last 24 hours. For example, if I have a measure: [sales] = 'Transactions'[Quantity]* 'Transactions'[Cost]. Does power bi have a feature to show that that [sales] measure has increased since yesterday, without creating extra tables on top of and/ or adding columns to the 'Transactions' table? 

I would ideally like to have an asterisk show up in the top corner of the visual if the measure has changed in the last 24 hours.

Thanks, any help that anyone would be able to offer would be greatly appreciated

[amitchandak]

@Anonymous , Here this change is vs last ETL (snapshot vs snapshot) or just yesterday vs today values?

If it  is snapshotvs snapshot. You have to create a table.these can help

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

if it today vs yesterday , you can try like

This Day = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))
Last Day = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])-1))
Last Day = CALCULATE(sum('order'[Qty]), previousday('Date'[Date]))

With a date table.

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions


Appreciate your Kudos.

[Anonymous · Accepted solution]

@amitchandak would only be for today vs yesterday. I think that might work, but let me try it and I'll let you know

[amitchandak]

@Anonymous , it is exact today

then

This Day = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date]=today()))
Last Day = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date]=today()-1))