Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have 4 tables. First one with region, day and a grade, second one with the region details and a third one with month and a collumn with the information about the grade necessity (yes or no) for witch month in the year and the last one is the calendar table.
I want a tale with the regions, information about necessity of grade (table3) and the count of grades (table1), it is possible do that with mesuares? It s important that i can use date filter in the dashboard, like the picture below.
PS: i cant conect table 1 and 3 because the many to many conection.
Solved! Go to Solution.
Hi @gpaula ,
To my understand, "Month" column in Table 3 represents each month. It should be matched with one column represents each month, too.
Therefore, please create a Month column in your Calendar table and use this column to create relationship between Calendar table and Table 3 like below.
Month = EOMONTH([Date],-1)+1
Then you can get what you want:
For more details, please check the attached .pbix file.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @gpaula ,
To my understand, "Month" column in Table 3 represents each month. It should be matched with one column represents each month, too.
Therefore, please create a Month column in your Calendar table and use this column to create relationship between Calendar table and Table 3 like below.
Month = EOMONTH([Date],-1)+1
Then you can get what you want:
For more details, please check the attached .pbix file.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi. Of course.
Table 1
Region | CodRegion | Day | Grade |
A | 01 | 18/10/2021 | 10 |
B | 02 | 18/10/2021 | 9 |
A | 01 | 19/10/2021 | 9 |
B | 02 | 20/10/2021 | 8 |
C | 03 | 20/10/2021 | 9 |
Table 2:
CodRegion | Detail1 | Detail2 |
01 | xxx | yyy |
02 | aaa | bbb |
03 | ccc | ddd |
Table3:
CodRegion | Month | Requested? |
01 | 01/10/2021 | yes |
01 | 01/11/2021 | no |
02 | 01/10/2021 | yes |
02 | 01/11/2021 | yes |
03 | 01/10/2021 | yes |
03 | 01/11/2021 | yes |
Is it enough?
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
19 | |
15 |