Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Oi pessoal, estou precisando de uma ajuda. Preciso calcular o Headcount da empresa.. consegui utilizando a seguinte fórmula: "FATEC Qtde de Beneficiarios = var DataMaxima = max('dCalendário'[Data]) Return CALCULAte( count(BeneficiáriosProjetoFATEC[CPF(ID)]), FILTer( ALL(BeneficiáriosProjetoFATEC), BeneficiáriosProjetoFATEC[Início Real]<=DataMaxima&& BeneficiáriosProjetoFATEC[DataFinal]>DataMaxima)" Infelizmente ele atende quando eu trago por Ano, mas eu precisaria trazer uma tabela com a coluna municipal. Será que alguém pode me ajudar?
Solved! Go to Solution.
Hi @MayaraRego ,
Due to I don't know your data model, here I will give you some suggestions. I think there should be a [municipal] column in BeneficiáriosProjetoFATEC table. Try ALLEXCEPT() function.
FATEC BeneficiariesQty =
VAR DateMaximum =
MAX ( 'Calendar'[Date] )
RETURN
CALCULATE (
COUNT ( BeneficiariesProjectFATEC[CPF(ID)] ),
FILTER (
ALLEXCEPT ( BeneficiariesProjectFATEC, 'BeneficiariesProjectFATEC'[municipal] ),
FATECProjectBeneficiaries[ActualStart] <= MaxDate
&& FATECProjectBeneficiaries[EndDate] > MaxDate
)
)
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @MayaraRego ,
Due to I don't know your data model, here I will give you some suggestions. I think there should be a [municipal] column in BeneficiáriosProjetoFATEC table. Try ALLEXCEPT() function.
FATEC BeneficiariesQty =
VAR DateMaximum =
MAX ( 'Calendar'[Date] )
RETURN
CALCULATE (
COUNT ( BeneficiariesProjectFATEC[CPF(ID)] ),
FILTER (
ALLEXCEPT ( BeneficiariesProjectFATEC, 'BeneficiariesProjectFATEC'[municipal] ),
FATECProjectBeneficiaries[ActualStart] <= MaxDate
&& FATECProjectBeneficiaries[EndDate] > MaxDate
)
)
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
12 | |
11 | |
8 | |
7 | |
7 |
User | Count |
---|---|
20 | |
14 | |
11 | |
10 | |
10 |