Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to view the Dynamic measure script ?

Hi All

My PBI File :-

https://www.dropbox.com/s/lqtacfyj7p09l4h/DYNAMIC%20MEASURE.pbix?dl=0

 

Need Help
  • manikumar34's avatar
    manikumar34
    5 years ago

    Anonymous ,

     

    Need not to do that. You can do this way and also unpivot the columns with the Power BI tranform options. 

     

    You have to select Amount and Cost columns on the table then in Transform tab use Unpivot columns. You will get the final result.

     

    regards, 

    Manikumar

13 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.

  • manikumar34's avatar
    manikumar34
    Solution Sage
    5 years ago

    Anonymous , 

    didn't get what you are trying to say. 

     

    Could you please elobarate more.

     

    Regards, 

    Manikumar

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi All

      if you open the file 

      there is attribute field 

      I want to know how to create ?

      • manikumar34's avatar
        manikumar34
        Solution Sage
        5 years ago

        Anonymous , It is unpivoted table, 

         

        You can refre to the Screenshot I shared on the last reply

         

        Regards, 

        Manikumar

  • manikumar34's avatar
    manikumar34
    Solution Sage
    5 years ago

    Anonymous , 

     

    I can see this is a Unpivoted data. 

     

    If you wanna look into it click on transform Data and the you can see the list steps applied on the table else you can also look into M query with Advance Editor. 

     

     

    Regards, 

    Manikumar

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Mani

      i try to open power quary , i notice that i am unable to view the script for attribute. below is the screen shot from my note book , pls let me know where i go wrong ?

       

      • manikumar34's avatar
        manikumar34
        Solution Sage
        5 years ago

        Anonymous , 

         

        The last step which Unpivoted columns is having the attrbute. 

        When we do Upivot the value will be changed from Columns to Rows. The column Names will become Attributes and the Row values will become Values. 

         

        Click Advance Editor to check the M query for all the steps done on the query. 

         

        Regards, 

        Manikumar

         

        If you think this is helpful, Please Accept as a Solution and leave a like.