Hi All,
In my application I need to have following chart
| Year-Month | Product % |
| 4,28% |
| 2016-04 | 0,17% |
| 2016-05 | 4,28% |
| 2016-06 | 4,19% |
| 2016-07 | 0,19% |
| 2016-08 | 4,28% |
| 2016-09 | 4,28% |
| 2016-10 | 4,28% |
| 2016-11 | 4,28% |
| 2016-12 | 4,28% |
| 2017-01 | 4,28% |
| 2017-02 | 4,28% |
| 2017-03 | 4,27% |
| 2017-04 | 4,27% |
I use expression below:
=sum({$<DateType = {Product},ProductDateKey = P(DateKey),[Item Number]-={"Y*"}, [Date]={">$(=addmonths(today(),-12))"}>}[Quantity] * [Product Weigth])
/
sum({$<DateType = {Operation}, OperationDateKey = P(DateKey),
[Date] = {">$(=addmonths(today(),-12))"} >}[Oper Quantity] * [Operation Weigth])
Chart shows correct data only when I select one year-month value:
| Year-Month | Product % |
| 0,22% |
| 2016-04 | 0,22% |
| Year-Month | Product % |
| 7,26% |
| 2016-08 | 7,26% |
Product and Operation tables have own date fields and they are linked by linkey table which contains - DataKey field
The reason of problem is following: my tables are linked by Item Warehouse and this key is too wide, so in chart I show Product % based on data for all period. If there a way to show correct data by set analysis? Because when I try to use Item Warehouse Date key I lost part of data from Operation table
Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").
