Forum Discussion
Power BI - Conditional sum column
VS_5 -
In addition to Unpivoting your fact table, I would add additional dimension tables for Account and Date. This will allow you to add meaningful groupings and other descriptive attributes. For example, your account table could begin with all of the distinct accounts, and then add a column for "Account Category", which could be used to put accounts into buckets.
I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
Thank you for taking time to respond to my query. I like the idea of Unpivoting the columns. As my actual table is huge and I'm trying to convert excel report to Power BI, I will have to use formulas like adding 2 or 3 cells with the condition on more than 2 Accounts (say Add Rev2 cost for accounts ABC, DEF and GHI).
So what is the best way to specify that condition on Accounts?
Again, thanks for your time.
VS_5 -
In addition to Unpivoting your fact table, I would add additional dimension tables for Account and Date. This will allow you to add meaningful groupings and other descriptive attributes. For example, your account table could begin with all of the distinct accounts, and then add a column for "Account Category", which could be used to put accounts into buckets.
I also appreciate Kudos.