Forum Discussion
Need help debugging a date based DAX formula
I tried to populate dates into a field called "Media Due" using certain criteria using the DAX formula below and based on what I can see, there aren't any visible errors with the formula (at the bottom of the DAX box). However, when looking at the report itself, nothing is populating in the "Media Due" field which contains the DAX formula. Any idea why this is happening? What am I doing wrong here?
Hi krichmond
Is [Media Due] a measure? If so, you may try adding MAX function to monthnumber and yearnumber in the formula. Just like below.
Media Due = SWITCH ( TRUE (), MAX ( mv_perfex[mediatype] ) = "Digital" && MAX ( dimstartdate[monthnumber] ) = 1 && MAX ( dimstartdate[Yearnumber] ) = 2023, "12/14/2022", BLANK () )Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
1 Reply
Hi krichmond
Is [Media Due] a measure? If so, you may try adding MAX function to monthnumber and yearnumber in the formula. Just like below.
Media Due = SWITCH ( TRUE (), MAX ( mv_perfex[mediatype] ) = "Digital" && MAX ( dimstartdate[monthnumber] ) = 1 && MAX ( dimstartdate[Yearnumber] ) = 2023, "12/14/2022", BLANK () )Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.