Hi All,
The issue is that this calculate formula shows no errors, but the results is incorrect:
= CALCULATE([Total Amount],fSales[Weekday]>1 || fSales[Weekday]<7)
Correct formula is:
CALCULATE([Total Amount],fSales[Weekday]>=2 && fSales[Weekday]<=6)
In fact, the incorrect formula doesn't apply any filter at all, and just brings[Total Amount].
I would like to understand what is happening and why an error messages is not display.
Regards,
Fernando
The issue is that this calculate formula shows no errors, but the results is incorrect:
= CALCULATE([Total Amount],fSales[Weekday]>1 || fSales[Weekday]<7)
Correct formula is:
CALCULATE([Total Amount],fSales[Weekday]>=2 && fSales[Weekday]<=6)
In fact, the incorrect formula doesn't apply any filter at all, and just brings[Total Amount].
I would like to understand what is happening and why an error messages is not display.
Regards,
Fernando