Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Unsure how to tie this together with Power Query (multiple MAXIFS)

Hopefully I can explain this clearly 🙂   I am trying to come up with a Matrix visualisation that will show the current open positions we have.   In my data model I have the crew plan, which show...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    5 years ago

     

    Anonymous 

     

    = #table({"Craft","Max_Count","PeakMonth","PositionsToFill","Location"},Table.ToList(ActiveStaff, each let a=Table.Sort(Table.SelectRows(CombinedCrewPlans,(x)=>x[Craft]=_{0}),{"Count",1}){0}? in if a=null then {_{0},null,null,null,null} else {_{0},a[Count],a[Date],a[Count]-_{2},a[Location]}))

     

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

sorry, i can not reach the file you provide. Anonymous 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    wdx223_Daniel  message me your email address and I will flick it over to you.