DAX Help

Question

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('CALENDAR'[Date]) +1 ),

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

)

Desired result =

25-11-2021 = 11-2021

26-11-2021 = 12-2021

25-12-2021 = 12-2021

26-12-2021 = 01-2022

anonymous · Answer

Hi&nbsp;Please try this&nbsp;YEAR - MONTH&nbsp; =IF&nbsp;(&nbsp;DAY('CALENDAR'[Date]) &gt;&nbsp;25&nbsp;,if(month('CALENDAR'[Date])&lt;12,CONCATENATE(&nbsp;YEAR('CALENDAR'[Date])&nbsp;&amp;&nbsp;"-"&nbsp;,&nbsp;MONTH('CALENDAR'[Date]) +1&nbsp;),CONCATENATE(&nbsp;YEAR('CALENDAR'[Date]) &amp;&nbsp;"-"&nbsp;,&nbsp;MONTH('CALENDAR'[Date]) )))

anonymous · Answer

Anonymous&nbsp;my requirement is different,&nbsp;&nbsp;25-11-2021 = 11-202126-11-2021 = 12-2021&nbsp;25-12-2021 = 12-202126-12-2021 = 01-2022

anonymous · Answer

SorryThis one should be okYEAR - MONTH&nbsp; =IF&nbsp;(&nbsp;DAY('CALENDAR'[Date]) &gt;&nbsp;25&nbsp;&amp;&amp; MONTH('CALENDAR'[Date])=12,CONCATENATE(&nbsp;YEAR('CALENDAR'[Date])+1&nbsp;&amp;&nbsp;"-"&nbsp;,&nbsp;«&nbsp;01&nbsp;»),IF&nbsp;(&nbsp;DAY('CALENDAR'[Date]) &gt;&nbsp;25&nbsp;,CONCATENATE(&nbsp;YEAR('CALENDAR'[Date]) &amp;&nbsp;"-"&nbsp;,&nbsp;MONTH('CALENDAR'[Date])+1 ),CONCATENATE(&nbsp;YEAR('CALENDAR'[Date]) &amp;&nbsp;"-"&nbsp;,&nbsp;MONTH('CALENDAR'[Date])))

anonymous · Answer

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

anonymous · Answer

Sorry for late reply. Time to have diner here.Your time intelligence work for other calculation in your PBIX ?

Forum Discussion

DAX Help

6 Replies

Related content

Dax

DAX

DAX Behavior

DAX Formula Help

DATEDIFF DAX