Forum Discussion
Add a column in table with dynamic column name.
I have a column name "Period".
I am using it in a Table Visual in Power BI.
So whenever the column "Period" is added to Table visual it should come up as current month.
Lets say I refresh it in month of march it shud come as "March" or If refreshed in April then "April".
Note: Dynamic changing column name in Power Query will break the report as the column names get changed in table visual and it throws error.
Please let me know if any further info is required.
The calculated column is static, so it cannot change dynamically, you can create a measure, the measure can change dynamically by the filter. You can refer to the following measure.
e.g
Measure = FORMAT(TODAY(),"MMMM")Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
The calculated column is static, so it cannot change dynamically, you can create a measure, the measure can change dynamically by the filter. You can refer to the following measure.
e.g
Measure = FORMAT(TODAY(),"MMMM")Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.