Usage Metrics across all workspaces CreationTime

Question

We used these instructions to pull in usage across all workspaces.

https://www.proserveit.com/blog/power-bi-usage-metrics-across-all-workspaces

It pulled in CreationTime, which is DateTime format

I need to see counts by month/Year

Because it is in the services, I cant create a column or measure. Is there any way to change the format to Month/Year?

v-luwang-msft · Answer

Hi&nbsp;mcornfield&nbsp;,
You could&nbsp; connect&nbsp; the dataset by Power BI desktop.&nbsp; thentry to add measure like below ,after it ,publish it to service,then open the report use service.
picture1:connect dataset
&nbsp;

picture2 :new measure

picture 3,publish&nbsp;

picture 4,open the report by using Service

&nbsp;
Wish it is helpful for you!
&nbsp;
Best Regards
Lucien
&nbsp;

v-luwang-msft · Answer

Hi&nbsp;mcornfield&nbsp;,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best RegardsLucien