Forum Discussion
mmoizk
Helper III
Helper IIICombining 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...
Sean
Community Champion
Community Championmmoizk Let me know if this helps! You obviously have to pick better names for the Columns!
- mmoizk
Thanks Sean, Just some clarifications. Days to Start and days to End are precalcuated days with datediff or 1*Today - startdate./endate. And can i combine results from both Start and ENd in one collective result
0-30 16
30-60 8
60-90 8
90 + 8
Gone 8
The idea is to encapsulate the requierement to one set of buckets for both dates.
TealCanadyAdvocate II
Sean I liked your solution as well.