Dynamic "IsLast4Quarters" in Extended DNA Date Table

Power Query
1

Hi all,

I have the extended DNA date table and would like to add a new calculate column "IsLast4Quarter so i can visually and dynamically show the last 4 quarters in a trend graph.

Can someone help?

Thank you.

2

I think I might have answered my own question. There is a column called CurrQuarterOffset. I can filter for only 0 to -3 and that should always give me the last 4 quarters.

Thanks all.

2 Likes