Forum Discussion
Different Calc Results
Hi All - I seem to be getting different results using the same filter critieria in the following functions - I'm basically trying to count open invoices on the last day of a month in a new summary ta...
Hi biuser431 ,
As checked the formula of the above these measures, I found that there are some conditions which applied on the formulas are different between them (Please check the below screenshots). I'm not sure if it cause the result of the second measure is incorrect... By the way, is there any blank values in the field 'Data'[Advanced Date Day]?
[Advanced Date] and 'Data'[Paid Date]
[Advanced Date] and 'Data'[Paid Date][Advanced Date Day] and 'Data'[Paid Date Day]
Best Regards