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.
Hi,
I have table with users where is column named "First Contract Date" , some are empty, type Date.
I need make calculation with another table "Events" where is hours time measure bo using only users with First Contract Date earlier than today.
I made this
CALCULATE( [Working Days]*8 - ([Days Vacation]+[Days Vacation S]+[Days Sick])*8 - [Hours Projects] - [Hours Sales], FILTER(Users, Users[First Contract Date] < NOW()))
Unfortunately I is not working, shows Hours for all users without filtering.
Hi @Marcin,
If there is relationship between your two tables? 'all users without filtering' means that the FILTER written in DAX didn't affect your measure? Could you please share more details or sample table as @vanessafvg said? So that we can post the solution which is close to your requirements.
Thanks,
Angelia
can you give some examples of the data with teh firstcontractdate, your new column
is this all in one table?
Proud to be a Super User!
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |