Table with different time dimensions

[Juju123]

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]

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