Forum Discussion
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...
Hi Anonymous ,
Which time intelligence are you referring to, maybe there are other alternative functions
If it doesn't work, it may also be related to the all() function inside. When the all() function is not used, at the day level we would always get one row from the calendar table, and when the all() function is used, the entire date table is returned.
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Time-intelligence-issues/m-p/1286680
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.