Completion rate of the month I selected from the Date Slicer

[berguven]

What formula should I use to see the completion rate of the month I selected from the Date Slicer in the relevant report?

For example, when I select April, it will perform the operation of today/last day of the month. (4/30=%13)

When I select March, it will be 31/31=%100 because March has ended.

When I select January-February-March-April, it will give the result of (31+28+31+4/31+28+31+30=%0.78).

I kindly request your support.

Thank you.

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rhn-1vTMxIImA6R7R?e=Nv7mVY

[berguven]

Thank you very much

[berguven]

month names

[berguven]

Slicer with date information

[Arul]

@berguven ,

Is it month names or dates?

Thanks,

Arul

[Arul]

@berguven ,

What is the column that you are using in the slicer?

Thanks,

Arul