Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I’m fairly new to DAX and have a two part question
CALCULATE (
COUNTX (
'Employees',
IF (
‘tblEmployees’[FTE] = "Yes" && ‘tblEmployees’[Curr_Emp] = "Yes",1)),
USERELATIONSHIP (‘tblEmployees’[Start_Date], Dates[Date_Value] ), Dates, Periods)
Many thanks in advance
Roy
Solved! Go to Solution.
You need the row function as I explain at the bottom of this article.
Hi @Anonymous,
To me, I would test the DAX formula in the Power BI Desktop or in the Excel with a model. That would be clearer.
Maybe this formula won't give you the result you want. Can you share a sample and the expected result?
Best Regards,
Dale
You need the row function as I explain at the bottom of this article.
Really good article for DAX Studio beginners.
Many thanks/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |