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!
mmoizkHelper III
Helper IIIThanks 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.