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])

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

Great suggestion, but I failed to mention that 'week' is a calculated column. If you look at my graph, you will see that 'week' is really 'week from today'. That is why there is a week 0 (these are the dates from yesterday and before).

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!!