Forum Discussion
Microsoft Employeeproblem with calculation-many to many
hi Dale,
thank you very much!
this is the sample
reminder: orig=1 means weekly data: 04/01 is 04/01 to 04/07
orig=2 means 28 days - 04/01 is 04/01-04/28
thanks!
Hi,
I am so sorry I still can’t make out the whole thing. But we can solve it step by step. I made a little mode with your sample.
1. Is this similar with yours?
2. Which columns in your sample are to be used?
3. What does the "measure X" mean? Can you post the formula if it has one.
4. Please have a look at the image in the bottom. Is this what you want? Or you can privide a sample visual.
Best Regards!
Dale
Microsoft Employeeplease please help?
thank you
v-jiascu-msftHi,
Could you post a little sample of your source data please. I have some questions about this:
1. Is the “Final Table” your source data or the result you want.
2. What is sum'Final Table'[Measure X]) for.
3. Is MeasureX a measure or a calculated column.
Best Regards.
Dale
- MP_123
v-jiascu-msftthsank you!
above is a little sample, if it's not enought i will share the whole table.
the final table is my source table, the measures i want to some is there.
measure X is a calculated measure
2. i want to have bar chart where X axis is the 4 weeks related, and Y axis is the measure
thanks again
- MP_123
how can I share an excel sample data?