Dear All,
I need help with representing a table in Power BI.
1) The expection from the table is that, each row have a different calculation and each of these rows pull data from a different source location. In my experience, I have always calculated column level values, however in this scenario the expectation is to have different row level calculations and the column are also not fixed and they vary. I am not sure if that's possible in Power BI.
2) The table should always present the June data first (Constant column) and then next column shall show current month's information (variable column) as we progress with rest of the year.
The expected table output in power BI is as follows:
| column1 | details | Jun'19 (Last year, last month) Constant | | | sep'19 (current year, Current month) | | | Current vs LY (June 2019) | | |
| | | Total | store | outlet | Total | store | outlet | var(+/-) | store | outlet |
| | | | | | | | | | | |
| Sales person | sales count | 66 | 9 | 57 | 64 | 9 | 55 | (2) | - | (2) |
| | location | 65 | 9 | 56 | 58 | 9 | 49 | (7) | - | (7) |
| | total | 62 | 9 | 53 | 56 | 9 | 47 | (6) | - | (6) |
Calls
info | call info | 12,630 | 930 | 11,700 | 13,241 | 1,021 | 12,220 | 611 | 91 | 520 |
| | target call | 78% | 68% | 79% | 80% | 62% | 82% | | | |
| | actual call | 13.7 | 5.5 | 15.0 | 13.5 | 5.5 | 15.0 | (0) | - | - |
| | | | | | | | | | | |
Table Notes:
1) Sample data is given for representation purpose only
2) The columns are having different datatypes
3) Rows like sales count, location , total , call info ...etc are derived with different calculations.
Please suggest ways to handle this scenario, any help would be greatly aprreciated.
Regards,
Rnagalla25
