The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I am trying to add 2 new columns in the matrix visual: to add 2 columns and subtract one column within the visual.
I do not want to create a column in the query editor as the dataset is huge and I did a direct query to fetch data. Please explain if anyone knows. Thank you. 🙂
I am trying to add Entry, Tag-on and subtract Undo for one column and similarly add exit and tag-off for the other new column. @needhelp
Facility | Entry | Exit | Undo | Tag-on | Tag-off |
chennai | 123 | 234 | 12 | 222 | 334 |
mumbai | 123 | 234 | 12 | 345 | 432 |
delhi | 134 | 234 | 12 | 212 | 122 |
kolkata | 564 | 234 | 11 | 122 | 111 |
Not entirely sure what you're looking for, a little clearer explanation would help.
Column 1 =
SUMX(Table, Table[Tag-on] + Table[Entry] - Table[Undo])
Column 2 =
SUMX(Table, Table[Exit] + Table[Tag-off])
The columns in this matrix visual table are not actual columns in the datasets. So, I get the error: Cannot find table, cannot find name.
I'm unable to create measures as well with the matrix visual column headers (Entry,exit,undo)
@Anonymous Can you show what the data looks like? You could reference the Measures instead of tables to get the effect you're looking for.
@Anonymous Thanks for the reply. The data looks like this:
In the matrix visual the ride_type is used as the column header and rows are taken from the facility. The values that needed to be added and subtracted are the count of txn_id.
Hope this makes sense. Thanks for your time 🙂
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
102 | |
82 | |
62 | |
56 |
User | Count |
---|---|
254 | |
119 | |
115 | |
99 | |
71 |