Forum Discussion
Data Modeling.
Hi Bhanu_chPBI ,
Are you think in terms of performance? Here I use the DISTINCT function because I want to return a single column table. If there are no duplicate entries in the date column of Table 3, you can also use the ALL function here, which is a table function that also returns a single column of the table.
Table =
DISTINCT (
UNION (
UNION ( DISTINCT ( Table1[Date] ), DISTINCT ( Table2[Date] ) ),
ALL('Table3'[Date])
)
)Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi Anonymous,
when i tried to use ALL Function i'm facing some issue in relationship. i have attached the screenshot below. issues shows some circular dependency.
Hi Bhanu_chPBI ，
What if you use the Dax provided for the first time? Does it also give error?
See if helps:
Avoiding circular dependency errors in DAX - SQLBI
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data