Forum Discussion

PDemolliens's avatar
PDemolliens
Frequent Visitor
2 years ago

Group tables with date and columns

Hello,

I very new with Power BI. I think it's very easy but I don't get it.

What I want. I want to summarize data with date.

This is my goal :

 

I have data from some differents tables.

This is my architecture.

So I would like have a table foreach year I have how many fiche_visite with the attribut IS_Animal_prod, same for carnivore....

 

I tried to summarized all fiche_visite with the date, is_animal_prod.

It works, but I would like to have only one table with all data and not just is_animal_prod but also is_carnivore etc.

SUMMARIZE(FICHE_VISITE,'Calendar'[Year],ANIMAL_ESPECE[IS_ANIMAL_PROD],"HOW MANY PROD",COUNTROWS(FICHE_VISITE))

 

Can you help me ?

Thanks.

 

1 Reply