Forum Discussion
How do I create needed table?
Hi everyone, I need help and am not even sure how to word my issue so please, be kind. I have a an Excel file that brings in two tables. The two tables have the same columns (except 1 has an...
Anonymous , One is you might have to append these two tables or create a few common dimension. Second I see measure to dimension conversion, I think you have to use calculation groups
Append : https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Another question...what if I cannot install Tabular Editor? Are there other ways to accomplish this?
You can copy the data from Excel and post it directly into the message
