Previous and next date from the calendar (metric)

[Anonymous]

Hi Everyone,

I have a table with different dates (screen) which shows when the source data for this table will be refreshed.

GOAL: using the TODAY () or other function to show on the card when the last data refresh was made and when the next will be (screen). Of course, with the change of the month, the metric should also go from P08 to P09 and so on (up to P12). Does anybody have any idea?

Screen with issue and expected result

Thank you very much in advance.

[Anonymous]

@amitchandak Thank you so much! It works! 🙂

[amitchandak · Accepted solution]

@Anonymous ,  Unpivot the table first to get P08 , P09 in rows

https://radacad.com/pivot-and-unpivot-with-power-bi

Then have measure like

last refresh =

var _period = "P"& format(Today(), "MM")

return

maxx(filter(Table, [period] = _period  && [Date] <= Today()) , [Date])

Nextrefresh =

var _period = "P"& format(Today(), "MM")

return

Minx(filter(Table, [period] = _period  && [Date] > Today()), [Date])