how to dilute period of dates into months

[felipeleite]

Preciso diluir o período de data em meses, por exemplo, data de início: 31/01/2022 data de término: 01/02/22, resultando assim janeiro = 1 dia; Fevereiro = 1 dia... Eu usei o DAX abaixo, ele funciona parcialmente, mas a soma está errada e eu não acho que o motivo ...

o gráfico abaixo funciona corretamente quando selecionado algum filtro, mas sem filtro não funciona...

Vou deixar os arquivos, quem puder me ajudar vai ficar muito grato!

[amitchandak]

@felipeleite , refer if these solutions can help

Between Dates - Dates between
Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

Tables way
https://amitchandak.medium.com/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2

[felipeleite]

hello Amit, thanks for the tips, are excellent, but i still could not solve my problem, I used your code as far as "dias por mes" the total sum is certain, but the distribution is not certain, I tried another code as far as "dias distribuidos" there is certain, but the sum is not, I will leave the link of my project, I would be immensely grateful if I could take a look, maybe you can help me, thank you very much!

https://drive.google.com/drive/folders/13OQkc3ETK5HdjZ1j5MPsWmM8gm8AFYYK?usp=sharing