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
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 but when I try to put it into a visual I get the error below. Anyone have an idea of what I might be doing wrong?
Solved! Go to Solution.
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])))
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])))
This is what I created but I'm only getting the Material column in the resulting table?
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.
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 |
---|---|
94 | |
92 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
121 | |
112 | |
58 | |
57 |