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
Unfortunately, I'm having trouble understanding what you're trying to do... Please show the desired result.
Hi again, I would like to add a column that calculates the average closed issue IDs, for all employees.
My question would be if it is possible if it can be done at the BI level instead of Exel..?