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

Hi

 

Please try this

 

YEAR - MONTH  =
IF ( DAY('CALENDAR'[Date]) > 25 ,if(month('CALENDAR'[Date])<12,
CONCATENATE( YEAR('CALENDAR'[Date]) & "-" , MONTH('CALENDAR'[Date]) +1 ),
CONCATENATE( YEAR('CALENDAR'[Date]) & "-" , MONTH('CALENDAR'[Date]) )
))
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Anonymous my requirement is different, 

 

25-11-2021 = 11-2021

26-11-2021 = 12-2021

 

25-12-2021 = 12-2021

26-12-2021 = 01-2022

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Anonymous  yes , It will work. wondering why time intelligence is not working here.