Table with different time dimensions

Juju123 — Tue, 19 Sep 2023 09:30:52 GMT

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 🙂

Re: Table with different time dimensions

lbendlin — Sat, 14 Oct 2023 18:31:00 GMT

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