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 everybody,
I am new in Power Bi & appreciate if anyone help me here:
I want to union the codes in 3 seperate tables and set the below formula which works correctly.
Maintenance WO = DISTINCT(union(FILTER(distinct(' Employee Hours'[Code]),'Employee Hours'[Code]<>""),FILTER(distinct(' Asset Hours'[Code]),'Asset Hours'[Code]<>"")))
Now, I want to add another condition for each table:
Simply, I just want to union the codes of two below tables if in employee table, crew type be MGMT and in Asset table, the crew type be Maint. Off course, empty codes must not be considered.
No idea what to do. your help would be highly appreciated.
Solved! Go to Solution.
Hi @Anonymous,
It works in my test. Did you make any changes?
Best Regards,
Dale
Hi @Anonymous,
You almost got there. Try the formula below, please.
Table = DISTINCT ( UNION ( CALCULATETABLE ( VALUES ( Employee[Code] ), FILTER ( Employee, ISBLANK ( Employee[Code] ) = FALSE () && Employee[Crew] = "MGMT" ) ), CALCULATETABLE ( VALUES ( Asset[Code] ), FILTER ( Asset, ISBLANK ( Asset[Code] ) = FALSE () && Asset[Crew] = "Maint" ) ) ) )
Best Regards,
Dale
Hi v-jiascu-msft,
Thanks for your time.
I tried your formula, but I got an error message that "Too few arguments were passed to the Union Function.The minimum argument count for the function is 2"
Any idea?
Thank you so much for your time and help
no one has any idea?
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |