Forum Discussion
Solved
DAX Formula IF Statement
I am trying to calculate Sum of Closed Accounts by Month. I have a column of Dates for the last invoice date for all our customers. I Created 2 Measures 9. Lastnonblank = CALCULATE(MAX(Da...
Hi, mcornfield
First, you need to check the format of the "IF Test" field. Text cannot be compared with the value 90.
Correct results can be obtained by modifying the format of the "IF Test" field.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, mcornfield
First, you need to check the format of the "IF Test" field. Text cannot be compared with the value 90.
Correct results can be obtained by modifying the format of the "IF Test" field.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.