Forum Discussion
I need count values in another no related table
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.
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)+1Then 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.
3 Replies
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?
- Icey
Community Support
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)+1Then 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.
