Forum Discussion

majdkaid22's avatar
majdkaid22
Helper 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 would be MTD_Revenue / past number of current month trading days * by remaining trading days of current month. 

 

I know it would invlove using the Calaendar, which happenes that I have a good one. 

 

Note: I would like to use [Is TradingDay" as a filter, so only actual trading days are counted. 

 

I appreciate your help in advance.

 

Majd

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,

1 Reply

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft 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,