Days remaining based on the slicer Month/Months picked

[Anonymous]

Hi,

I have need a measure on days remaning based on the month or months selected in the slicer 

1. If month is previous month the days remaining would be 0 

2. If mont is current month the days remaining would be total days in month minus days passed in the month

3. If month is future month the days remaining would be Total days in the month 

If Current month and future month is selcted then the remaning days would be 2 +3 

[Anonymous]

@Anonymous 

Can you try the below and let me know whether it matches your requirement

No of Days = IF(
SELECTEDVALUE('Table'[Date].[MonthNo])<MONTH(Today()),
0,
IF(
SELECTEDVALUE('Table'[Date].[MonthNo])=MONTH(Today()),
EOMONTH(Today(),0)-Today(),
(EOMONTH(Today(),0)-Today())+(EOMONTH(DATE(YEAR(Today()),SELECTEDVALUE('Table'[Date].[MonthNo]),1),0)-Today())))