Forum Discussion

pawlowski6132's avatar
pawlowski6132
Helper V
5 years ago
Solved

Challenging DAX Problem

Ok, I've been struggling with this all day.   I have two tables: 'Forecast' and 'Working Days'.   The 'Forecast' table has month and  forecast amount [FK Forecast]. The 'Working Days' table has ...
Need Help
  • Payeras_BI's avatar
    Payeras_BI
    5 years ago

    Hello @pawlowski6132 ,

    I've invented my forecast numbers, but I hope it helps

    Payeras_BI_0-1605081725344.png

    Payeras_BI_0-1605084898355.png

pawlowski6132's avatar
pawlowski6132
Helper V
5 years ago

For example.

 

February 2021 Forecast = 17,270

Working Days in February 2021 = 17

Average Volume per Working Day in February = 1,016

 

Put 1,016 for each "Working" day row where Month is Febraury.