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 Experts,
I am creating a new table that collect all the dates of two other tables by using following formular.
Date Table =
UNION (
SELECTCOLUMNS('Overall Result',"Date",'Overall Result'[Date]),
SELECTCOLUMNS('Hiring Manager List',"Date",'Hiring Manager List'[Created]))
Is it possible to add some formular to remvoe duplicated date in this new table at the same time?
Many thanks!
Best regards,
Tom
Solved! Go to Solution.
Hi Tom,
You could use DISTINCT
DISTINCT(
UNION (
SELECTCOLUMNS('Overall Result',"Date",'Overall Result'[Date]),
SELECTCOLUMNS('Hiring Manager List',"Date",'Hiring Manager List'[Created]))
)
or consider doing the table using Power Query
/Erik
Hi Tom,
You could use DISTINCT
DISTINCT(
UNION (
SELECTCOLUMNS('Overall Result',"Date",'Overall Result'[Date]),
SELECTCOLUMNS('Hiring Manager List',"Date",'Hiring Manager List'[Created]))
)
or consider doing the table using Power Query
/Erik
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |