How to calculate percentage based on Date range slicer

[Anonymous]

Hi! I'm tring to calculate percentage of month based on Date range slicer on the dashboard.

Such as ;
November = 30 days

Date on slicer = 11/01/2022-11/15/2022
Percentage = 50%

If date range on slicer is 12/01/2022 - 12/19/2022 , then percentage = 61.29%
so this percentafe should change as Date slicer.

I've created Date table and add measure to count date of every month, but still cannot count date as slicer.
How should I do?

[Uzi2019 · Accepted solution]

Hi @Anonymous 
Please do the following steps:  2 seperate measures

1) Create last date measure (It will calculate last day of date selected like 30/31)

Edate_ = day(EOMONTH(MAX('Calendar'[Date]),0))

2) Create new measure for % calculation ( It will count the no of days between 2 selected date range)

         Datesum =

           Var Total =DATEDIFF(MIN('Calendar'[Date]),MAX('Calendar'[Date]),DAY)+1

           Return (Total/[Edate_])

Check the result:
I hope I answered your question please give kudos and accept it as a solution!
Thanks

[Anonymous]

Thank you @Uzi2019 , It's work!

[Uzi2019]

Hi @Anonymous 
Did you try my solution???

If it helps please give kudos and accept it as a solution!

[rubayatyasmin]

Hi, @Anonymous 

Lets break down the solution into parts. 

For days: 

Calculate the days selected in the date range

TotalDays = COUNTROWS(DATESBETWEEN('Date Table'[Date], MIN('Date Table'[Date]), MAX('Date Table'[Date])))

calculate the number Of days in the month for the start date selected in a range.

DaysInMonth = CALCULATE(
COUNTROWS('Date Table'),
FILTER(
'Date Table',
MONTH('Date Table'[Date]) = MONTH(MIN('Date Table'[Date])) &&
YEAR('Date Table'[Date]) = YEAR(MIN('Date Table'[Date]))
)
)

calculate the percentage:

PercentageOfMonth = DIVIDE([TotalDays], [DaysInMonth])

[Anonymous]

HI! @rubayatyasmin thank you for your reply

but as this 
TotalDays = COUNTROWS(DATESBETWEEN('Date Table'[Date], MIN('Date Table'[Date]), MAX('Date Table'[Date])))

the result is still not change as date selected in a range. It's still count all date of the data, even I've only chosen 1 month.

Did you have any advice for this?

Thanks

[rubayatyasmin]

can you provide a demo file?

[Anonymous]

Sure

[Uzi2019]

Hi @Anonymous 
Did u try my answer ???