Summarize a table by month, year, and type

[JoseLuisAGZZ]

Hi yall

Im facing a problem that is I want to count the distinct id of a table based on the type 
So the tables are basically like this:

hist:
id_eqip      date                 status
1               01/01/2023       ok

2               01/01/2023       ok

3               01/01/2023       ok

1               01/02/2023       ok

2               01/02/2023       ok
3               01/02/2023       ok
1               01/03/2023       ok
2               01/03/2023       ok

and the other one is
eqip:

id_eqip    type
1              box

2              monitor

3              full-eqip


so what I expect to see is a chart or table where I can count the distinct number of eqip by type,month,year something like this

Type               Month        year        Qty
Box                 Jan            2023         2
Monitor          Jan            2023         3
full-eqip         Jan            2023         1
Box                 Feb           2023         2
Monitor         Feb            2023         4
full-eqip        Feb            2023         6

any help will be highly appreciated

[Greg_Deckler]

@JoseLuisAGZZ How is the Qty being calculated from your sample data? I don't understand why Box has 2 for January for example. 

[JoseLuisAGZZ]

In this case is an example, but the Qty is calculated by how many times the item apears in the hist table in that month or week and by type of item, so if the item 1 appear 3 times in week 1 and 2 in week 2 but the type is box I want that item to be summarized with the other ones that are box too

for example:
i have the hist table and the eqip table, combining this two tables I want to have a dax or summarized table that looks like this

item      date                  type
1            01/01/20223    box
2            01/01/20223    box

3            01/01/20223    box

4             01/01/2023     monitor

So when I filter that table I want the result to looks like this:
Month    Qty    Type
Jan           3       Box
Jan           1       Monitor

and so on with other months and weeks, so I can check how many items by type, week,month  are in the hist table registered