Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |