Solved: Dax to M

Anonymous · ‎01-13-2021

Hi, can you help me traslate this to M ? Need a custom column:

Train_no_unique = SWITCH(TRUE(),
MONTH(BPS[date])<=11,YEAR(BPS[date])&"_"&BPS[TRAIN_NUMBER],
YEAR(BPS[date])+1&"_"&BPS[TRAIN_NUMBER])

artemus · ‎01-13-2021

I think it would like:

= if Date.Month([date]) <= 11 then Text.From(Date.Year([date])) & "_" & [TRAIN_NUMBER] else Text.From(Date.Year([date] + 1)) & "_" & [TRAIN_NUMBER]

please note that M is case sensitive, so if your column is Date use Date not date.

artemus · ‎01-13-2021

I think it would like:

= if Date.Month([date]) <= 11 then Text.From(Date.Year([date])) & "_" & [TRAIN_NUMBER] else Text.From(Date.Year([date] + 1)) & "_" & [TRAIN_NUMBER]

please note that M is case sensitive, so if your column is Date use Date not date.

Dax to M