Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Olá comunidade!
Preciso realizar essas duas medidas para um projeto:
1) Valor vendas vencidas (vendas total – desconto)
[quando data de vencimento <= dia de análise]
2) Valor inadimplência total (vendas total – desconto)
[quando data de vencimento <= dia de análise e [quando não houver data de pagamento]
Como consigo resolvê-las em DAX?
Segue em anexo o arquivo pbix.
Obrigada!
https://drive.google.com/file/d/1WUPgL834dXHxZD5Ri0au7ybPuYuI43eo/view?usp=sharing
Solved! Go to Solution.
Hi, @Flavia_helena ;
Try it.
VALOR VENDAS VENCIDAS =
CALCULATE (
[VALOR TOTAL VENDAS] - [VALOR TOTAL DE DESCONTO],
FILTER ( fVENDAS, fVENDAS[Data Vencimento] <= MAX(dCALENDARIO[Date] ) )
)
Valor inadimplência total = CALCULATE([VALOR VENDAS VENCIDAS],FILTER('fVENDAS',[Data Pagamento]=BLANK()))
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Flavia_helena ;
Try it.
VALOR VENDAS VENCIDAS =
CALCULATE (
[VALOR TOTAL VENDAS] - [VALOR TOTAL DE DESCONTO],
FILTER ( fVENDAS, fVENDAS[Data Vencimento] <= MAX(dCALENDARIO[Date] ) )
)
Valor inadimplência total = CALCULATE([VALOR VENDAS VENCIDAS],FILTER('fVENDAS',[Data Pagamento]=BLANK()))
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
100 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
104 | |
85 | |
73 |