Forum Discussion

sameergupta60's avatar
sameergupta60
Helper IV
3 years ago

Dax Help

Hi all,   we need help with the below query.   The row-wise avg of GPL staff is correct.   Row wise avg of gpl staff is correct.   when we at the overall total  506/2022 avg is 25 but i...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Referring to your MS Excel file, The Zonal1 table in PowerBI Desktop rquires a lot of cleaning up.  First of all, all total and calculation columns should be removed.  Next, all columns columns other than the first 3 should be "Unpivoted".

This is when your data would become amenable for any analysis,.

  • sameergupta60's avatar
    sameergupta60
    Helper IV
    3 years ago

    Hi,

    Please give me a solution to that query.

     

    Regards,

    Sameer 

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      3 years ago

      Hi,

      In the file that you are feeding to PowerBI desktop, just remove all calculated columns/rows/total columns/total rows.  Once loaded, select the first 3 columns, right click and click on "Unpivot Other Columns"

      • sameergupta60's avatar
        sameergupta60
        Helper IV
        3 years ago

        Hi ,

         

        I removed all the calculation column & rows but my purpose has yet not been resolved.

         

        Regards,

        Sameer