topic Table Visual to Table in Desktop

Table Visual to Table

Anonymous — Mon, 29 Jun 2020 03:23:10 GMT

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! 🙂

Re: Table Visual to Table

parry2k — Mon, 29 Jun 2020 03:27:47 GMT

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.⚡

Re: Table Visual to Table

amitchandak — Mon, 29 Jun 2020 03:29:00 GMT

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/

Re: Table Visual to Table

Anonymous — Mon, 29 Jun 2020 03:34:54 GMT

This works, thank you all!