Forum Discussion

majdkaid22's avatar
majdkaid22
Icon for Helper V rankHelper V
9 years ago
Solved

predictive measure

  H i guys,   I have a MTD measure for Revenue.    I would like to have a measure  to predict what would be the closing month Revenue, based on the the current revenue.    I know the logic ...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    Hi, In this scenario, to calculate the past/ remaining trading days in current month. You can filter the table context based on TODAY() and IsTradingDay. The count measure can be like:

     

     

    Past Trading Days in Current Month=
CALCULATE (
    COUNTA ( Calendar[Date] ),
    FILTER (
        ALL ( Calendar[Date] ),
        Calendar[Date] >= DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 )
            && Calendar[Date] <= TODAY ()
            && Calendar[IsTradingDay] = 1
    )
)

     

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi, In this scenario, to calculate the past/ remaining trading days in current month. You can filter the table context based on TODAY() and IsTradingDay. The count measure can be like:

 

 

Past Trading Days in Current Month=
CALCULATE (
    COUNTA ( Calendar[Date] ),
    FILTER (
        ALL ( Calendar[Date] ),
        Calendar[Date] >= DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 )
            && Calendar[Date] <= TODAY ()
            && Calendar[IsTradingDay] = 1
    )
)

 

 

Regards,