Forum Discussion

krichmond's avatar
krichmond
Helper IV
3 years ago
Solved

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 bott...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    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.

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

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.