Columns visual across report formating

Hi learner03,

Your excel file has different values than the based data, but it will be easier for me if we would talk about same numbers.

We need to figure out why dose differences appear, so the calculated columns would work perfect:

1. Column D - Available Qty: you put here numbers: 30, 100, 80 & 500, but non of the item has such Available Qt in thier data. How is it calculated?

2. Column F-J - Stock Due: How did you calculated that? I used a measure that was Sales * Item price (row calculations), but we have different numbers, so I know that I made something wrong. Can you put some formula here so I will check where is difference?

3. Columns L-Q - Sales: Even here you have different numbers (without any formula), but based on the data I have different results.

4. Columns S-X - Forecast: Same here. You've provided a sample data with forecasting value, but on the Output table it seems like it's forecast based on formula, not the data. Forecast for Jan 2023 is ok for me, but I need to know how is is calculated for future months. Provide the formula OR the correct input data for Forecast table.

5. Creating additional Header row, Column(s) based on different columns is possible the same way as the previous ones.

6. Due to fact that I didn't create new columns I will show you how to do the conditional formating on forecast field:

Conditional formating =

SWITCH(SELECTEDVALUE('Custom Columns'[Header Name]),

"Forecast",

    SWITCH(TRUE(),

        [Forecast] > 500, "Green",

        [Forecast] < 300, "Red"

    )

)

 

Results: