Dynamic "Column" Headers for Time Periods in Power BI

Great content. In the interest of saving someone else time, make sure to use a CALCULATED COLUMN, not a Measure. I was skipping through the video to get to the DAX and missed the instruction to create a calculated column. Thus promptly wasted an hour trying to get a measure to work.

Hello ! thank you soooo much for the great video with very amazing instruction ! one question please, for var: Historical = 'Calendar'[Date] .... is 'Calendar'[Date] a measure or simply a date column ? my 'Calendar'[Date] is a date column and when i put in there, it shows greyed out, thanks !!

This is a very clever solution. Thanks for sharing! I just received an identical request so this is super helpful. Thanks!

Hello ! Thanks for the content ! Do you know if it's possible to manage the name of calculation group items as you do in your calculated column ? I would like to have dynamic names based on slicers value, but I'm don't find any solution to do it.

People are awesome! Great job! Thanks for sharing!

How come your 'Calendar'[Date] is not greyed out? When I try this, my 'Calendar'[Date] in greyed out as a first argument after AND. The error says "A single value for column 'Date' in table 'Calendar' cannot be determined. This can happen..."

Historial

How do you do this when using direct connect (e.g. AAS Tabular)

Hi. Grate solution! I have a similar problem. I need to define de current date in the page filter. Is it posible? Thanks

Hi without using a slicer can we change the column header dynamically ?... Is it possible ?

Hello, I have a query similar to this.
I have a table with different month columns of the previous year and the current year. So in my current table previous_01 is Jan 2020 and Current_01 is Jan 2021 and so on.What my customer wants that column should be dynamic and not static. So if we refresh data next year, the column name Previous_01 should change into Jan 2021 and not Jan 2020. Similarly, for column name Current_01 should change into Jan 2022 and not Jan 2021. Any idea how to achieve this?

Historial*

This is really Super cool :) . Thank you very much for sharing this however i can see the calculations are really heavy with better results and performance.

Brilliant!

In all your CALCULATE statements, you use Table filters instead of Column filters, this slows your calculations heavily.

Awesome..👏