Calculation of days according to period

[Syndicate_Admin]

Esteemed buen day

I need help to determine, from a period, how many days correspond to each month
That is: if I have a period from May 1, 2023 to October 12, 2023

I want to filter by May, show me 31 days

or if I want to see August, September and October show me

	August	September	October
Days	31	30	12

Of course, thank you very much

Best regards

Mathias

[Syndicate_Admin]

I manage to do it but when the calendar has the specific range.
Can you help me with an example of these 4 lines?

DOC	DateFrom	Dateto
1	06-07-2023	05-09-2023
2	06-07-2023	05-08-2023
3	06-07-2023	05-10-2023
4	01-01-2023	31-12-2023

Thanks a lot

[Syndicate_Admin]

Thank you for your prompt reply...

I'm starting with Power Bi and it's hard for me to adapt to the logic.

Do you think it possible if I give a value to each line, calculate the value corresponding to each month?

I come from excel and I have serious problems to change the logic of the processes.

Of course, thank you very much

[NaveenGandhi]

Yes, Just creating the measure or using aggregate in values field will show the value corresponding to each month in the visual.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

[NaveenGandhi]

Hello @Syndicate_Admin 

You just create a count of date column and use matrix visual to visualize as you have stated.

Let me know if you need any help or question.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.