Forum Discussion
Issue on rename column dynamically
Hi all, Refer to this post: https://community.powerbi.com/t5/Desktop/Auto-renaming-columns-based-on-value-in-another-table/m-p/79018 I am able to rename the column based on current date, i....
phchu1226 , Create a column in table and use
Switch( True(),
[Date] < today() -1 , "Week 0" ,
[Date] > today() , "Week " & quotient(datediff([Date], Today(), Day),7) +1
)
Hi amitchandak,
I had tried this DAX, the result is not what I expected.
I just want to rename the column name based on date.