Forum Discussion
Dax formula - Select value - all except
Good morning, I am trying to create a new column ( example below" created " column is the result I would like to get ). The new column should copy the value of the " DEN" column for each KPI ( takin...
Hi Anonymous ,
Can you explain why these rows get 150? As your description, they should copy the column den.
| Volumes | 2021 YTD - 02 | AOA Cluster | Oceania | Pakistan | MN | Medical Nutrition | 616 | 616 | 0 | 0 | 150 |
| GPS | 2021 YTD - 02 | AOA Cluster | Oceania | Pakistan | MN | Medical Nutrition | 8839,1286 | 8839,1286 | 0 | 0 | 150 |
| OthRev | 2021 YTD - 02 | AOA Cluster | Oceania | Pakistan | MN | Medical Nutrition | 0 | 0 | 5819,913 | 0 | 150 |
| COGS | 2021 YTD - 02 | AOA Cluster | Oceania | Pakistan | MN | Medical Nutrition | 2223,9234 | 2223,9234 | 5819,913 | 0 | 150 |
| Comm & OVE | 2021 YTD - 02 | AOA Cluster | Oceania | Pakistan | MN | Medical Nutrition | 12,8834 | 12,8834 | 5819,913 | 0 | 150 |
| VDC 3P | 2021 YTD - 02 | AOA Cluster | Oceania | Pakistan | MN | Medical Nutrition | 216,1187 | 216,1187 | 5819,913 | 0 | 150 |
| TDC | 2021 YTD - 02 | AOA Cluster | Oceania | Pakistan | MN | Medical Nutrition | 5332,1178 | 5332,1178 | 5819,913 | 0 | 150 |
| Structural Costs | 2021 YTD - 02 | AOA Cluster | Oceania | Pakistan | MN | Medical Nutrition | 1332,2886 | 1332,2886 | 5819,913 | 0 | 150 |
| NNS Aff | 2021 YTD - 02 | AOA Cluster | Oceania | Pakistan | MN | Medical Nutrition | 2189,4962 | 2189,4962 | 0 | 0 | 150 |
Best regards
Community Support Team _ chenwu zhu
This is a mistake, den for Pakistan market is 150