Forum Discussion

mmoizk's avatar
mmoizk
Icon for Helper III rankHelper 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!

Sean's avatar
Sean
Icon for Community Champion rankCommunity 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
Icon for Helper III rankHelper 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)

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    10 years ago

    ALL calculations are in PBI!

    Those are Calculated Columns in PBI!

    • mmoizk's avatar
      mmoizk
      Icon for Helper III rankHelper III
      10 years ago

      Exactly , want is the calucation done there?

    • mmoizk's avatar
      mmoizk
      Icon for Helper III rankHelper III
      10 years ago

      Exactly , i was looking for what calculation were used to calcuate (Basically the formula ) did you use DateDiff or 1*(StartDate - today())

      • TealCanady's avatar
        TealCanady
        Icon for Advocate II rankAdvocate II
        10 years ago

        mmoizk,

        I was actually asking for you calculation that was failing on datediff.

         

         

        Teal