Forum Discussion
Solved
How Do You Count Rows of YYYY-MM and Present As A Bar Chart In YYYY-MM Time Series Order
I started with Power BI Desktop yesterday and even after reading many forum posts and trying to use Measures I cannot seem to achieve what I beleive is fairly simple. From the example table below...
Hi TJM_UK
ah ok you're using Direct Query. OK a different approach. Create a table from the data you get from Azure. Click New Table in the Ribbon then use this code
Year_Month = SELECTCOLUMNS('Table', "YearMonth", FORMAT([CreatedDate], "yyyy-mm"), "Name", [Name])Creates this
Then use that table to create the visual
Regards
Phil
PhilipTreacy
Super User
Super User
Yes of course. The backend is an Azure SQL database. Not sure if that is the issue. I can't seem to find how to create the Count of Name variable where right clicking gives this:
Hopefully the link here works. Not sure how accessing the back-end Azure database will work for you.