Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
https://www.dropbox.com/scl/fi/5im1lyjgzg2pa0bhhlcil/PBIPQ.xlsx?dl=0&rlkey=fnu7pyv3na3b7oa5nmo35seq9
Sheet 1 contains source data set example (and also fetched into Power BI as a table
Sheet 2 show how I would like to have an additional table - filtered by some of the fields in the source table
I would appreciate if someone could provide me with a pbix file describing how this task could be accomplished
Solved! Go to Solution.
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHello, thanks for helping. I will attach an excel source file, and a Power BI file that will show my problem. In the pbix i'll assume that source has to be altered according to where one stores theexcel file.
Thanks in advance
https://www.dropbox.com/s/opru44hkhlj9h2r/Test.pbix?dl=0
https://www.dropbox.com/scl/fi/97o2o60bfygmgb8dtdzyh/DB.xlsx?dl=0&rlkey=nnp07r7fai5ojka80f2e8gnuq
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThanks a lot - this will make it possible for me to get my data into a matrix, as you suggest 🙂
Great @claper57 - 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!
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingMay 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.