Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |