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.
Hi there,
I want to achieve a similar result as in Excel, which I can input data in a table and calculate the result accordingly.
As the screenshot below, I have my data from the data model in column B, and I want to add a few more columns that I can also adjust the percentage easily.
Can someone please advice?
Thanks
Solved! Go to Solution.
Hi @dgdgdg122db ,
We can achieve that by merging tables in power query. Please check the following steps as below.
1. Enter the input 1 and input 2 and insert index column for all the tables.
2.After that, merge the table as below.
3. Based on the merged table, add the custom columns like that.
Then we can get the excepted result as we want.
For more details, please check the pbix as attached.
Hi @dgdgdg122db ,
We can achieve that by merging tables in power query. Please check the following steps as below.
1. Enter the input 1 and input 2 and insert index column for all the tables.
2.After that, merge the table as below.
3. Based on the merged table, add the custom columns like that.
Then we can get the excepted result as we want.
For more details, please check the pbix as attached.
Probably, you can use What-if Parameter (from Modeling - What if), and create 5 parameters; set the data type, the min and max values you may expect it. Then you can use them as slicers in the dashboard.
I know this is not professional but at least it may work.
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |