How to handle different granularities in Power BI

Picture this for example: you are dealing with your daily sales figures and suddenly you need to compare them with long-term yearly targets. This request comes very often from stakeholders. How would you handle this in your data model? DAX? Well like almost everything in Power BI, there is more than one solution…

Published August 15, 2023