Forum Discussion

pawlowski6132's avatar
pawlowski6132
Icon for Helper V rankHelper 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

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago

I was able to replicate this and can confirm it works as described. I'll have some challenges because my dataset is a bit more complicated and I will have to modify to fit but, thanx SO much. I was missing the correct modeling and use of the RELATED function. You're the best. Thank you for taking the time to help me.