The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
11 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
23 | |
14 | |
13 | |
10 | |
8 |