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 ,
I have this requirement where i have one column from which i need to get the Diff_amount and %Change
The column Diff_amount and % change contains large rows, so i need to replicate the same formula for this column.
With excel i can easily perform a drag and drop operation. How this can be performed in powerbi adding a calculated columns.
Solved! Go to Solution.
In Power BI, rows in table has no sequence internal. So if you want to handle some "previous/next" scenario on row level, you must create an index column in your table. You can do it in Query Editor. Then you can create your calculated column based on this index column easily.
Regards,
Hi,
Unfortunately your solution did not worked. Any other idea?
In Power BI, rows in table has no sequence internal. So if you want to handle some "previous/next" scenario on row level, you must create an index column in your table. You can do it in Query Editor. Then you can create your calculated column based on this index column easily.
Regards,
Hey,
first create a calculated column using the LOOKUP() function
LOOKUPVALE('yourtable'[Amount], 'yourtable'[Year],'yourtable'[Year]-1) - 'yourtable'[Amount] for DiffColumn (or the other way round)
then, just create a calculated column using both columns
Hope this helps
Regards
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |