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!

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

Thanks Teal , datediff isn't working for future dates

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

Can you show me your exact formula? DateDiff should be agnostic of future dates. =DateDiff(GetDate(),[EndDate],Day) should work; if you can send me the error / formula that would be great.

 

 

Teal