Table with different time dimensions

Juju123 · ‎09-19-2023

Hello 🙂 ,

I would like to know if it is possible to create this type of table in Power BI.

I have a reference date which is today's date.

The user will have the possibility to modify the reference date, depending on the date he has chosen,

I wish:

Show dates lower than this reference date
Display the 12 months rolling in relation to this date
Display the last 5 in relation to the date selected. Do you have any idea how I could make this table in Power BI. The numbers in the table are an indicator.

Thanks for your help 🙂

lbendlin · ‎10-14-2023

Sure it's possible but you are looking at creating a truckload of measures. Consider using separate visuals.

Helpful resources