Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I need to create a table containing the different dates that are in 3 columns of another table:
Example: Table1 contains the columns: Data1, Data2 and Data3
Table2: contains a column with the dates of columns Date1, Date2 and Date3
I need to filter all these dates using a slicer, that's why I need to bring all the dates from these columns in a single column, so I can filter them at once
Hi CastroRibeiro,
You can use "UNION" dax functions to get this. Please refer to the below function.
Appreciate a Kudos!
If this helps and resolves the issue, please mark it as a Solution!
Regards,
N V Durga Prasad
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
90 | |
84 | |
70 | |
49 |
User | Count |
---|---|
141 | |
120 | |
112 | |
59 | |
59 |