Forum Discussion

ebrownretail's avatar
ebrownretail
Resolver I
1 year ago
Solved

Input Snow Range

Hi! I am trying to find what my snow range is based on the weekly history snow totals. Currently, this is not filling in. Can you please help figure out what to do or whats wrong? I need to take thi...
Need Help
  • ebrownretail's avatar
    ebrownretail
    1 year ago

    So i just figured it out by thinkging of a Vlookup in excel and was able to get it to work!

     

    Find Range history =
    LOOKUPVALUE('Weather Range'[Snow Range], 'Weather Range'[Snow], [Weekly totals])
ebrownretail's avatar
ebrownretail
Resolver I
1 year ago

i need it to be the specified range as sales work differently based on different snow amounts.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi All
Firstly  lbendlin thank you for your solution!
And ebrownretail ,you can try the treatas function, it should be able to accomplish your needs, you can filter the snowrange according to snowtotal, I hope my solution is helpful to you, I will be honored if I can solve your problem!

Measure = CALCULATE(
MAX('Table (2)'[Snow Range]),TREATAS(VALUES('Table'[Snow Total]),'Table (2)'[Snow]))

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

 

  • ebrownretail's avatar
    ebrownretail
    Resolver I
    1 year ago

    hi!

    I just tried this but am getting this error.

     

    Find Range history =
    CALCULATE(MAX('Weather Range'[Snow Range]), TREATAS(VALUES('A - Snow Measures', [Weekly totals]), 'Weather Range'[Snow]))

     

    Too many arguments were passed to the VALUES function. The maximum argument count for the function is 1.