Forum Discussion

SimonAbs's avatar
SimonAbs
Frequent Visitor
8 years ago
Solved

Calculate(Count (....), (Datesbetween(....)) returns nothing

Hey guys :)   I insert the following Measure in Power BI Desktop:   Latest_NPS = CALCULATE(COUNTA(NPS[nps_category]);DATESBETWEEN(NPS[ts];[LastestDate_NPS_Start];[LatestDate_NPS_End]))   It ret...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi SimonAbs,

     

    You can try to use below formula to calculate records between specific date range:

    Latest_NPS =
VAR currStart =
    MAX ( NPS[LastestDate_NPS_Start] )
VAR currEnd =
    MAX ( NPS[LatestDate_NPS_End] )
RETURN
    CALCULATE (
        COUNTA ( NPS[nps_category] );
        FILTER ( ALLSELECTED ( NPS ); NPS[ts] IN CALENDAR ( currStart; currEnd ) )
    )

    Regards,
    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi SimonAbs,

 

You can try to use below formula to calculate records between specific date range:

Latest_NPS =
VAR currStart =
    MAX ( NPS[LastestDate_NPS_Start] )
VAR currEnd =
    MAX ( NPS[LatestDate_NPS_End] )
RETURN
    CALCULATE (
        COUNTA ( NPS[nps_category] );
        FILTER ( ALLSELECTED ( NPS ); NPS[ts] IN CALENDAR ( currStart; currEnd ) )
    )

Regards,
Xiaoxin Sheng

  • SimonAbs's avatar
    SimonAbs
    Frequent Visitor
    8 years ago

    Hi Anonymous,

     

    Thanks for the fast reply.

    It works perfect :)

     

    Best regards,

    Simon