Forum Discussion
Table Visual to Table
Hi!
Is there a way to convert a table visual into a real table?
Status_Measure column is a measure that I created in Submission table
Date references in a different table named Date_Reference
While the Employee ID is from a table named Roster.
Can these three table get connected as well to produce the output?
THANK YOU! 🙂
Anonymous yes, you can write this dax expression to create a table,
New Table = SUMMARIZE ( SubmissionTable, DateTable[Date], SubmissionTable[Employee], "Status", [Status Measure] )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Anonymous , Not sure I got it.
Put all the columns in summarize columns and create new table
https://docs.microsoft.com/en-us/dax/summarizecolumns-function-dax
https://www.sqlbi.com/articles/introducing-summarizecolumns/
3 Replies
Anonymous yes, you can write this dax expression to create a table,
New Table = SUMMARIZE ( SubmissionTable, DateTable[Date], SubmissionTable[Employee], "Status", [Status Measure] )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Anonymous , Not sure I got it.
Put all the columns in summarize columns and create new table
https://docs.microsoft.com/en-us/dax/summarizecolumns-function-dax
https://www.sqlbi.com/articles/introducing-summarizecolumns/