Forum Discussion
One to many error
Hello
I wanted to start out a question about the issue having in a matrix trying to figure out the error given on particular level of granularity , when explosing the matrix, for the SameperiodLastyear formula
I've reported an example which actually is working for APE PY but not totally because it has same figures all the time but I had stated a one-to-many relationship before which should solve
What am I doing wrong ?
Thanks
https://www.dropbox.com/s/7e5quic41ev2ddm/OneToMany.pbix?dl=0
papuzu , I added a date table and changed the measure, refer to the file attached after signature
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
2 Replies
papuzu , I added a date table and changed the measure, refer to the file attached after signature
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4Hello thanks for your solution
how to manage an HY sum of results ? I have reported values correctly for each quarter I would like to add mid-year sum. thanks
https://www.dropbox.com/s/l681ajzhvdri1q4/OneToManySolution.pbix?dl=0
