Can i use current date (month and year) as a part of column name in DAX

[BarSi1986]

Dear All,

I want to include current date - month + year in following format: ["some text" & current month-current year] as a Custom Measure Name in my power bi project =- i need to achieve dynamic column (measure) names depending on current date, for example:

sales value - January 2021, sales value - February-2021

i did this in power Query like below: 

 "sales value - "  &   Date.ToText(Date.From(DateTime.LocalNow()), "MMMM/yyyy")

but i need to achieve it in BI Desktop cause i need the name for custom measure

any ideas ?

[smpa01]

@BarSi1986  try this measure

Measure= "sales value - "&FORMAT(TODAY(),"mmmm/yyyy")

[BarSi1986]

but i don't want to have it in my ROWS, i neend to have dynamically changing HEADER of this custom measure column - values need to be calculated as i will do it, but i need DATE to be a part o NAME/HEADER of this column

[smpa01]

@BarSi1986  sorry are you desiring for a measure that dynamically changes the HEADER/NAME of the measure?

[BarSi1986]

of course,

it should look like this: 

but the headers can;t be hardcoded as a text - month name should dynamically change with formula

something like that i achieved in power query using: 

"sales value - "  &   Date.ToText(Date.From(DateTime.LocalNow()), "MMMM")

need to achieve the same in DAX

[smpa01 · Accepted solution]

@BarSi1986  as far as I know it is not possible to dynamically change the  name/header of the measure

[amitchandak]

@BarSi1986 , Are you looking for a column like

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

Month Type = Switch( True(),
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

[BarSi1986]

I don;t exactyl know actually, can u show me how can i use it as a Custom Measure Column name - i mean as a header of custom measure column ?