SUM of number of dates

[Sohan]

I have the following measure that counts the number of appointments on any given day in the coming 6 months.

SUM of 6 months appointments = 
IF(
    MAX(Datum[Date]) <= TODAY(),
    CALCULATE(
        SUMX( ALLSELECTED(Datum[Date]), [Rolling 6 month] ),
        DATESINPERIOD(
            Afspraken[Datum afspraak],
            MAX(Afspraken[Datum afspraak]),
            6,
            MONTH
        )
    )
)

Rolling 6 month = CALCULATE(COUNTROWS(Afspraken), DATESINPERIOD(Afspraken[Datum afspraak], TODAY(), 6, MONTH),
FILTER(Afspraken, Afspraken[Status] = "Planned"),
FILTER(Afspraken, Afspraken[Soort afspraak] <> "Phone call"))<p> 

The values I get aren't correct though, is the line stays flar for far too long. When I'm manually checking the values, they are incorrect. Does anyone know why this might be?

[Anonymous]

Hi @Sohan ,

It's better to share some sample data and expected result so that we could help you with the formula.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 

Best Regards,

Jay

[amitchandak]

@Sohan , Try like

Rolling 6 month = CALCULATE(COUNTROWS(Afspraken), DATESINPERIOD(Afspraken[Datum afspraak], TODAY(), 6, MONTH),
FILTER(Afspraken, Afspraken[Status] = "Planned" &&  Afspraken[Soort afspraak] <> "Phone call"))

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Sohan]

@amitchandak Thanks for your reply! Unfortunately, nothing changes when I edit the code like you suggested.