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

Share sample pbix file to help you.

  • Arjun_reddy's avatar
    Arjun_reddy
    Helper I
    3 years ago

    Hi Ahmedx,

     

    I am unable to add power bi and excel file, please find the below attachment.

     

     

    Thanks,

    Arjun Reddy.

  • Arjun_reddy's avatar
    Arjun_reddy
    Helper I
    3 years ago

    Please find the below data table

    categoryyearsales
    chairs20215000
    tables20216000
    bulbs20226000
    sofa20224500
    chairs20228000
    chairs20216000
    chairs20212800
    sofa20224700
    bulbs20222000
    sofa20215500
    tables20216000
    tables20223400
    bulbs20214000
    • Ahmedx's avatar
      Ahmedx
      Super User
      3 years ago

      you can show what result you expect

      • Arjun_reddy's avatar
        Arjun_reddy
        Helper I
        3 years ago

        result should be have as mentioned rounded yellow color in snap