Solved: If with text and numbers if possible

Anonymous · ‎04-05-2023

Hi Experts

Is it possible to have a IF DAX Calculated Column formula to incorporate both text and numbers.

Measure =

if(FACT[year_str] = 2022, "Current year-1",[year_str])

Greg_Deckler · ‎04-05-2023

@Anonymous You can do this:

if(FACT[year_str] = 2022, "Current year-1",[year_str] & "")

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Greg_Deckler · ‎04-05-2023

@Anonymous You can do this:

if(FACT[year_str] = 2022, "Current year-1",[year_str] & "")

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

If with text and numbers if possible