Forum Discussion
Problem with union (selectcolumns
Tablemeasure = Union(
selectcolumns(Table A,"Opening_Date", Table A[Opening_Date]),
selectcolumns(Table B,"Business_Date", Table B[Business_Date]),
) I created a measure using this format above bu...
If you need a list of dates for a visual, create a calculated table instead of a measure :
CombinedDatesTable = UNION( SELECTCOLUMNS(TableA, "Date", TableA[Opening_Date]), SELECTCOLUMNS(TableB, "Date", TableB[Business_Date]) )then for the measure :
UniqueDateCount = DISTINCTCOUNT(UNION(SELECTCOLUMNS(TableA, "Date", TableA[Opening_Date]), SELECTCOLUMNS(TableB, "Date", TableB[Business_Date])))
Can you please share your pbix file ?
Your solution worked, I just had to tweek it a bit for my situation. I accepted your solution.