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 |
---|---|
87 | |
85 | |
68 | |
67 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |