Forum Discussion
Solved
Create a Table via DAX based on another table
Hello I need to create a table in DAX based on another table which adds records based on conditions. I created a mock pbix (link below) https://drive.google.com/file/d/1btS457OqSeBEZIvrnH9gb29l...
I have determined a way to do this which involves manipulating the data in Power BI to allow use of the matrix in the way that I want. Thanks for reviewing!
Thanks for reaching out to us.
>> The issue is that for records that have a "split" Category, I need to allocate sales and quantity information into materials and labor and include it in the proper area of the report.
please give the expected output from the given sample file
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
I have determined a way to do this which involves manipulating the data in Power BI to allow use of the matrix in the way that I want. Thanks for reviewing!