Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAX Help

Hi experts, below measure is giving wrong results in case of december month, please help   YEAR - MONTH  = IF ( DAY('CALENDAR'[Date]) > 25 , CONCATENATE( YEAR('CALENDAR'[Date]) & "-" , MONTH('CA...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Sorry


This one should be ok

YEAR - MONTH  =

IF ( DAY('CALENDAR'[Date]) > 25 && MONTH('CALENDAR'[Date])=12,

CONCATENATE( YEAR('CALENDAR'[Date])+1 & "-" , « 01 »),

IF ( DAY('CALENDAR'[Date]) > 25 ,

CONCATENATE( YEAR('CALENDAR'[Date]) & "-" , MONTH('CALENDAR'[Date])+1 ),

CONCATENATE( YEAR('CALENDAR'[Date]) & "-" , MONTH('CALENDAR'[Date])))