Forum Discussion
anonymous_98
4 years agoResolver I
DAX comparison operations do not support comparing values of type Date with values of type Text
Error Message: DAX comparison operations do not support comparing values of type Date with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values. can you p...
- 4 years ago
I have found the solution for this.
here is the piece of code in the DAX code which caused issue.
before fixing:
CALCULATETABLE( VALUES(Sales[Customer ID]), FILTER( ALL(Sales), Sales[Purchase Date] >= _DateBeforeNDays & Sales[Purchase Date] <= _EndOfMonthDate ) )After fixing:
CALCULATETABLE( VALUES(Sales[Customer ID]), FILTER( ALL(Sales), Sales[Purchase Date] >= _DateBeforeNDays && Sales[Purchase Date] <= _EndOfMonthDate ) )why the error caused in the first place?
--> if you see in the first code, instead of using && operator I was just using & operator. and that was the only reason for the error.
Syndicate_Admin
3 years agoAdministrator
Hi, switch does not evaluate all conditions
GLOOMY CREDIT =
SWITCH(
TRUE(),
[TOTAL DCLIENTES] =1,600000000,
[TOTAL DCLIENTES]= 2, 750000000,
[TOTAL CUSTOMERS]= 3, 700000000,
0
)
TOTAL DCLIENTES =
DISTINCTCOUNT(cupocredito[DCLIENTE]).
If I do it with sum, I don't do it either.
If I do it with sum, I don't do it either.
TOTAL DCLIENTES =
SUM(cupocredito[DCLIENTE])
Thank you
Thank you