Forum Discussion
Helper VAdding individual Measures in a table or matrix
Hi,
I have this project where I'm converting excel forecast model into pbi. Below is my expected output which is currently the excel layout. I intend to recreate this in PBI but I've not been successful in doing that. Please note, each row (numbered 1-10) contain independent measures. I've attached a pbi sample dataset with some measures for reference. Any help or guidance on this will be highly appreciated
https://drive.google.com/file/d/1TetOpo8Uid_04AqVyQ9gi1cIMRg6Ap9W/view?usp=sharing
3 Replies
- amitchandak
Super User
Emmy66 , Looking at the layout calculation group should help you
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Emmy66Thanks amitchandak for the prompt response. I will check it and let you know if I got it sorted. Much appreciated.
- Emmy66
Hi amitchandak thanks for the link. I found it very helpful as it helped me to understand how calculation group can be applied. I tried out a few things but I got stock along the line.
I created 2 calculation groups as shown in the screenshot below but my challenge is how do I place e.g. the qty on the right against the actual which is what I expect the output to be. Your help on this is apprecated. The updated pbix is on the link I posted previously.
