Forum Discussion
dashboard with dynamic date
Hi blabla702
The quick and dirty solution is to create resolution year and resolution month calculated columns :Use these 2 columns as slicers:
And create a column chart with distinctcount aggregation:
The pbix is attached
The most efficient approach is to learn about Star Schema, work with a calendar table, and master DAX.
I've attached links to high-quality learning materials, as it's impossible to summarize the essence of working with the tool in a few sentences within a forum discussion.
Star schema:
https://www.youtube.com/watch?v=7ciFtfi-kQs
The creation of the dim date guide includes the following scripts :
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns
The dax basics
https://www.youtube.com/watch?v=QJw4HkagVWcIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi blabla702
The quick and dirty solution is to create resolution year and resolution month calculated columns :
Use these 2 columns as slicers:
And create a column chart with distinctcount aggregation:
The pbix is attached
The most efficient approach is to learn about Star Schema, work with a calendar table, and master DAX.
I've attached links to high-quality learning materials, as it's impossible to summarize the essence of working with the tool in a few sentences within a forum discussion.
Star schema:
https://www.youtube.com/watch?v=7ciFtfi-kQs
The creation of the dim date guide includes the following scripts :
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns
The dax basics
https://www.youtube.com/watch?v=QJw4HkagVWc
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.