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

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
7 years ago

Hi wlknsn 

No need to pre aggregate data if your table is not massive, I would try DAX and if performance is not satisfactory then you can consider aggregating yuor data.

 

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

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

Is there an easy way to do convert that data into monthly records in powerquery?

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Hi wlknsn 

    You can use "Group By" its fairly simple  

    Thanks

    Mariusz