Forum Discussion

airwolf39's avatar
airwolf39
Icon for Helper V rankHelper V
5 years ago
Solved

Need a measure to select a Week

Hi Folks,   The first part of my  probelm was fixed. I can now find the date when inventory goes to 0 using this forumula:   Now i need a measure that will select the week that the "N...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    airwolf39 

    Ok, try:

    week num = LOOKUPVALUE(Date Table [Week], Date Table [Date], [No inv Date])

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

airwolf39 

Ok, try:

week num = LOOKUPVALUE(Date Table [Week], Date Table [Date], [No inv Date])

airwolf39's avatar
airwolf39
Icon for Helper V rankHelper V
5 years ago

Oh my goodness, i didnt realize that I could use lookupvalue in a measure... i thought it was restricted to creating calculated columns... what a game changer! Thank you!!