Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Miscellaneous filters

Hi!
I need to make a calculation between the "Cobertura" value of the events that are in the "Ocorrência" tab
(only "Ocorrência válida?" in "SIM") and the "Base" tab of those who have the "Situação Contrato" "ATIVO".

So that the "Referência" tab is the guide, and the columns "INICIO" as the start date delimiting the period, "FINAL" as the end date
period delimiter and "REFERÊNCIA" as the period identifier.

In short, I need to check if the cases in the "Ocorrência", "Dt. Evento" tab are contained in "Dt. Início Vigência" and "Dt. Fim Vigência" of their
respective "Contrato" on the "Base" tab and check the name of the equivalent month on the "Referência" tab (considering the "INICIO" and "FINAL" columns).
So that I can reach the goal that is to divide the "Cobertura" value of the "Base" tab with the "Ocorrência" tab.
I must preserve the possibility of using filters such as "Modelo Veículo", "Tipo Veículo". 
File for illustration 

 

 

 

2 REPLIES 2
daXtreme
Solution Sage
Solution Sage

Hi @Anonymous 

 

Here's a piece of very good advice. Please follow. Thanks.

Anonymous
Not applicable

Hi @Anonymous ,

 

Have trouble to follow. Can you share the expected result?

 

Best Regards,

Jay

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.