topic Re: Formula to show Items with Majority of Forecast in DAX Commands and Tips

Formula to show Items with Majority of Forecast

DeeCeesQuestion — Tue, 16 Jan 2024 18:31:04 GMT

Hi - my company has four different warehouses and the same stock code can be in both warehouses. Within the warehouse, we have customer groups and forecasts are created for each stock code by warehouse and customer group.

For my warehouse, "88" in the example below, I want to show items where the stock codes make up the majority of the forecast compared to the other warehouses. I don't know how to create the command or if I'm in the right place.

Re: Formula to show Items with Majority of Forecast

Anonymous — Wed, 17 Jan 2024 02:24:43 GMT

Hi DeeCeesQuestion ,

You can try formula like below:

TotalForecast = SUM('Table'[Jan FC]) + SUM('Table'[Feb FC]) + SUM('Table'[Mar FC])

Warehouse88ForecastPercentage = IF(ISBLANK([TotalForecast]), BLANK(), DIVIDE( CALCULATE( [TotalForecast], VALUE('Table'[Warehouse]) = 88 ), [TotalForecast] ) )

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly