Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Folks
I get a problem with dates comparison or conversion (I don't know).
On the dax result panel underneath it is said that it is impossible to convert "avril" from txt to integer.
Solved! Go to Solution.
I can't tell what the problem is but you can make the definitions simpler by taking advantage of EOMONTH.
VAR _DateDebutMois = EOMONTH ( DateProjet[Dates], -1 ) + 1
VAR _DateFinMois = EOMONTH ( DateProjet[Dates], 0 )
VAR _NBJoursMois = DAY ( _DateFinMois )
I can't tell what the problem is but you can make the definitions simpler by taking advantage of EOMONTH.
VAR _DateDebutMois = EOMONTH ( DateProjet[Dates], -1 ) + 1
VAR _DateFinMois = EOMONTH ( DateProjet[Dates], 0 )
VAR _NBJoursMois = DAY ( _DateFinMois )
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |