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,
From what i read, the creation date is of no use. So create a Calendar Table with calculated column formulas for Year, Month name and Month number. Sort the Month name column by the Month number. Create a relationship (Many to One and Single) from the resolution date to the date column of the calendar table. To any vsual, drag Year and Month name from the Calendar table.