Forum Discussion
Power query to create Power BI table
See the attached file. It returns this:
Your data did not match your expected output. For example, C2 & C3 had no income values, and C1 had no expenses.
I would do the totals in DAX using the totals feature of a Matrix or Table.
See the attached file. It returns this:
Your data did not match your expected output. For example, C2 & C3 had no income values, and C1 had no expenses.
I would do the totals in DAX using the totals feature of a Matrix or Table.
Thanks a lot - this will make it possible for me to get my data into a matrix, as you suggest 🙂
Great Anonymous - glad I was able to help. Unpivoting and re-pivoting can be awesome transformation tools in Power Query. Have fun with the rest of your project!
May I ask another question? I think I would like to have this pivoted table created based on an existing Power BI table (I have already imported the one you used as source in excel) Lets say my existing table is named fProjects, and have the same columns as earlier mentioned (one record per project)
I would like to have a new table based on fProject and call it fProjectPiv. fProjectPiv will have to look like your result table, but the values has to reflect fProject values, sliced via Department etc
Is this possible?I'm not sure what exactly you are asking, but you can have one table in Power Query use another as the source and then have them both load into Power BI. I'd need more details to understand the question though.