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.
I have several files combined using power query. The first table is the data for the base file while the second table is the data for the compared file. The 2 tables are obliged to several universal slicers (applied to both tables coherently). I wish to make a new table comprising two columns, unit difference and unit percentage difference.
Example output:
Here provided the example of pbix and files:
https://drive.google.com/drive/folders/1nYQ_Q3p7crChalNrWNdWb7sIdSqhBns9?usp=sharing
I would like to know how to do this. Appreciate any help given. Thank you.
Solved! Go to Solution.
Hi @Anonymous ,
According to your descriptin, here's my solution.
In Power Query, select Cruzer Capacity Plan table, then click Merge Queries>Merge Queries as New.
Merge tables with the date column.
Then add two custom columns.
unit difference=[Compared.Unit]-[Unit]
percentage difference=[unit difference]/[Unit]
Remove unwanted columns, get the new table.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
According to your descriptin, here's my solution.
In Power Query, select Cruzer Capacity Plan table, then click Merge Queries>Merge Queries as New.
Merge tables with the date column.
Then add two custom columns.
unit difference=[Compared.Unit]-[Unit]
percentage difference=[unit difference]/[Unit]
Remove unwanted columns, get the new table.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
what you ask for is doable.
however, it would be useful to have tables in the format of the screen shot you showed in your post
Covering 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.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |