Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Add custom column to Usage Metrics

I am using the Usage Metrics dataset for my workspace.  I want to enrich the dataset with a day of week column or measure.  I am looking for usage trends by day (ie. Monday vs Friday etc.).

 

I cannot seem to find a way to either add a custom column or create a measure in the Power BI usage dataset that I can use in my report.  Can someone suggest an approach.

Need Help

7 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Anonymous ,

     

    I'm afraid the usage metric is automatically generated by power bi service based on the dataset. You can create an extra report/visual to reach your requirement.

     

    Community Support Team _ Jimmy Tao

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      v-yuta-msft  Jimmy, thanks for your reply.  Yes, I am working within the restriction that the dataset is generated by the Power BI service.  I have connected to the dataset and created my own custom report - I need guidance on how to create a custom column and/or measure to enrich the data set and allow me to report by the day of the week.

      • v-yuta-msft's avatar
        v-yuta-msft
        Community Support
        7 years ago

        Anonymous ,

         

        Could you share more details about your specific requirement and post some sample data?

         

        Regards,

        Jimmy Tao