Forum Discussion
Custom Column Measure required for a complex data set
Hi All,
I am new to power bi, so need your help in creating a reporting.
Sample Table data:
Required Report format:
The above is the formula used in the excel, similar view wanted to create in power bi for diff fields. I want to calculate Delta, BL & IM.
Please help me ASAP.
Hi Anonymous ,
Please refer to these posts:
Difference between Column Values in Matrix Visual;
Custom aggregate column in power bi matrix;
YoY Growth in Different Section in Matrix Table.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Anonymous Sorry, having trouble following, can you post sample data as text?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.Hi Anonymous ,
Please refer to these posts:
Difference between Column Values in Matrix Visual;
Custom aggregate column in power bi matrix;
YoY Growth in Different Section in Matrix Table.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
