predictive measure

[majdkaid22]

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

[majdkaid22]

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

[v-sihou-msft · Accepted solution]

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,