Forum Discussion

Arjun_reddy's avatar
Arjun_reddy
Helper I
3 years ago
Solved

dax query

Hi Community team,   I need you help on build dax query for second largest retail channel on total sales I am sharing the code for first largest retail channel  on total sales  1largest_TotalCha...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

    https://1drv.ms/u/s!AiUZ0Ws7G26RihMKgrmog1QqoECj?e=OQNfR6

     

    If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Ahmedx's avatar
Ahmedx
Super User
3 years ago

Is this what you are looking for?

Ahmedx's avatar
Ahmedx
Super User
3 years ago

or this&

  • Arjun_reddy's avatar
    Arjun_reddy
    Helper I
    3 years ago

    Hi  Ahmedx,

     

    not that solution, my query is i want to get the category on which is the second highest sales in category on max year, In the data , chairs is having second highest sales, please write the query on my concern.
    result should get as: chairs contributed with sales value