Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
The thing is that I have to create a report with four different tables:
I am asked to create a dropdown filter (slicer) with the format of "Month Year", i.e, September 2018. Nevertheless, I have different dates from each table (Hire Date, Created Date, Response Date and Evaluation Date are not the same, some tables even have more rows than others).
I guess that I have to create a date table, I did it with the following code (my first question is, is this ok?):
I want to show some indicators such as:
With the above information, I want to know how to create the data model/relationships, I did the following model:
As you can see, I can't set the relationships Dates-Tickets and Dates-Quality as active, so, whenever I select the slicer as "April 2018", it does not show the Evaluation Score (from Quality) of that month, instead, it shows the Score of all the data.
How can I solve this?
@Julio9704 , Do not join ticket or quality.
or
1. Create one merge table ticket or quality and use that.
2. Same as above use this new table and ticket table
3. same as 2. but have one common dimension between new table and ticket table
These will make a star schema and you will be able to work
Sorry for a basic question, what tables should I merge in step 1?
@Julio9704 , Combined = tickets and quality (merge https://radacad.com/append-vs-merge-in-power-bi-and-power-query)
1. Keep one if it solve purpose
2. Keep combined and tickets
3. Keep combined and tickets and common dimension like ticket
4. combined and ticket will join to date as fact
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |