I have actually created a solution but I am wondering whether there is a better, more efficient way of achieveing the outcome I am looking for.
What I am seeking to achieve is to create a series of summary cards on a visualisation that highlight key indicators for the lastest month, which is dynamically updated each month. I require a card that highlights the latest period (month and year) and cards for the the KPI’s. In the example attached ,I only created a card fror sales but there could be multiple cards.
The steps I took were.
To filter for the last month, I used the related function to copied the Month Number from the Dates table into the Sales table and then created the following measure
Last Month Sales = CALCULATE([Sales], FILTER(Sales, Sales[MonthNum] = MAX(Sales[MonthNum])))
The measure I used to highlight the last month was
Last Month = FORMAT(MAX(Sales[OrderDate]), “MMM YYYY”)
My question is that given the Dates table has colums for both the Month Number and MonthYear could these measure have been built directly addressing the Dates table rather than copying the Month Number colum into the Sales table.
PracticeModel.pbix (410.7 KB)