Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
The dax measure I need help with is "Driver Active Days". It returns the values correctly at the fiscal period level; however, it's wrong when it rolls up to the fiscal year level. The fiscal year 2019 should return a value of 1743, not 2431. Can anyone help tweak it please? Thank you.
The data model looks like this:
The PBIX files can be downloaded here
@Anonymous , Change return like this and try
Sumx(Addcolumns( summarize( FactEmployeeHistory, DimDate[Year], DimDate[Period]), "_1", IF(NOT(ISBLANK([Driver working Hours])), days)),[_1])
@amitchandak It doesn't work because there is no relationship between FactEmployeeHistory and DimDate.
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |