Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
89 | |
86 | |
75 | |
69 | |
68 |
User | Count |
---|---|
214 | |
128 | |
117 | |
82 | |
76 |