Forum Discussion
Power query to create Power BI table
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 ...
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.
Hello, 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