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.
Hello,
I created a Table in PowerBI Desktop:
Solved! Go to Solution.
Yes, but I don't have any table to UNION them from.
IE the data exists only in my head and I want to enter it into the table
You could use the Enter data button to create a new table with the data in your head or else define it as a DATATABLE with DAX.
Hi @kressb ,
then you must create the table in the same structure with DATATABLE
https://docs.microsoft.com/en-us/dax/datatable-function
@AlexisOlson @mwegener
Ok, so selected enter data, created another table with my manual data - used all the same columns in the exact same order and formated them all correctly.
went back to the original table I created. called that one var _Table1 and then set a Union:
Update: read this thread: Union column order - Microsoft Power BI Community
Had to add a nested Summarize to the Second New Table to get it to work..
Seems like a lot more work than it should be...
Your second table needs to match the columns of the table you are unioning it with, not the original shape of the table you are summarizing. Having [UniqueID1] twice in your summary might make this problematic.
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |