Forum Discussion

amsrivas's avatar
amsrivas
Icon for Helper IV rankHelper IV
5 years ago
Solved

How to combine text with current year in M Query

Hi Guys,

I want to write Power BI M query that  will combine Text and Current Year

 

i.e.  Variable = Text + Current Year

                     = "02/" + Date.Year(DateTime.LocalNow())

 

Any suggestion ?

 

Thanks

Amit 

1 Reply