Forum Discussion

malqinneh's avatar
malqinneh
Regular Visitor
9 years ago
Solved

DAX Measure with Nested IF Statements

Hi, I'm wondering how I can create a nested if statement on DAX to return a value. If my date falls between A and B, Return Week1, OR if it falls between A and B, Return Week 2... and so on.   T...
  • TomMartens's avatar
    TomMartens
    9 years ago

    Hey,

     

    so it looks similar, but the DAX parser / engine sometimes is not that smart, for this reason use

     

    AND(Issues[Created Date]>= DATE(2017,7,21) ...

    instead

     

    Regards

malqinneh's avatar
malqinneh
Regular Visitor
9 years ago

Thank you!