Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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
Hi @Anonymous ,
Have trouble to follow. Can you share the expected result?
Best Regards,
Jay