Count Number of Past Days in Current Month Except Sundays

[markefrody]

Hi,

Appreciate if you can help me with the following:

1.) Is there a DAX in counting the past number of days in the current month excluding today and Sundays?

2.) Is there a DAX to count the remaining days of the current month excluding today, Sundays, and past days.

Best regards,

Mark

[MarcoPessina]

Hi @markefrody ,

try these measures:

Days Before Today = CALCULATE(
    COUNTROWS('Date'),FILTER(
        'Date','Date'[Date]<TODAY() && MONTH('Date'[Date])=MONTH(TODAY()) && WEEKDAY('Date'[Date])<>7)
        )

Days After Today = CALCULATE(
    COUNTROWS('Date'),FILTER(
        'Date','Date'[Date]>TODAY() && MONTH('Date'[Date])=MONTH(TODAY()) && WEEKDAY('Date'[Date])<>7)
        )

 Hope it helps.

Cheers,

Marco

[markefrody]

@MarcoPessina 

Hi Marco,

Thank  you for the measure. I have tried using it but the number of days are not computing properly. I have attached the sample data for your reference.

Sample data

Best regards,

Mark V