Forum Discussion

mmoizk's avatar
mmoizk
Helper III
10 years ago
Solved

Combining 2 different if statements in one

Trying to calculate days bucket for 2 dates against today's date. For example TargetStartdate and TargetEndDate. I did my dax for Start and end sperately and its working fine but I need to combine th...
Need Help
  • Sean's avatar
    Sean
    10 years ago

    mmoizk Let me know if this helps! You obviously have to pick better names for the Columns!

mmoizk's avatar
mmoizk
Helper III
10 years ago

Thanks Teal , datediff isn't working for future dates

Sean's avatar
Sean
Community Champion
10 years ago

mmoizk

  • mmoizk's avatar
    mmoizk
    Helper III
    10 years ago

    Thanks Sean, how did u calcuated Start days ?

    • Sean's avatar
      Sean
      Community Champion
      10 years ago

      I've put all formulas in the pictures? Which one do you mean?

       

      Starts = COUNTA('Table'[START])

      • mmoizk's avatar
        mmoizk
        Helper III
        10 years ago

        Days to Start and Days to End in your Excel (i know its based of the start date and today's date)