Forum Discussion

wlknsn's avatar
wlknsn
Icon for Helper I rankHelper I
7 years ago
Solved

Best Practice: Extrapolation/Forecasting

Before I starte waisting hours on finding the best practise on this topic, I though I might just ask given the question is pretty simple.   Let's say you have a model with the following data: Cust...
Need Help
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    Hi wlknsn ,

    In your scenario, I would use the following DAX query to do that:

    Result =
CALCULATE (
    SUM ( Data[Monthly fee] ),
    FILTER (
        ALL ( Data ),
        Data[Start Date] <= MIN ( 'Date'[Date] )
            && Data[End Date] >= MAX ( 'Date'[Date] )
    )
)

    The result will like below:

    Best Regards,

    Teige

TeigeGao's avatar
TeigeGao
Icon for Solution Sage rankSolution Sage
7 years ago

Hi wlknsn ,

In your scenario, I would use the following DAX query to do that:

Result =
CALCULATE (
    SUM ( Data[Monthly fee] ),
    FILTER (
        ALL ( Data ),
        Data[Start Date] <= MIN ( 'Date'[Date] )
            && Data[End Date] >= MAX ( 'Date'[Date] )
    )
)

The result will like below:

Best Regards,

Teige