Forum Discussion

chesterraepined's avatar
chesterraepined
Icon for Helper I rankHelper I
8 years ago

Need help with DAX functions

I created a measure that will calculate the total number of days up to the last date present in my data. In my current data the MAX or last current date is June 28 218. I'm almost getting the correct...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi chesterraepined,

 

There could be an issue in your formula. The IF statement could always return the true value. There could be two workarounds.

1. Wrap the formula with Calculate( ..., all('InitialResponse-Assoc')).

2. Create a new date table then count days directly.

 

 

Best Regards,

Dale