Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Rolling 6 months

Hi Experts   Trying to work out the rolling 6 months to start at a specific date in my table - my measure is (but i cannot see the error)   Rolling 6 mnth =  VAR _Min = Min(BM Historic[Month Yea...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Anonymous ,

     

    I didn't understand your DAX measure and I also think it can't work as there are some errors.

    If you want to get rolling 6 months data, you should try the following approach:

    Rolling 6 mnth =
CALCULATE(
    Sum('BM Historic'[Value]),
    DATESINPERIOD(
        'DateTable'[Date],
        MAX('DateTable'[Date]),
        -6,
        MONTH
    )
)

     

    Be aware, that you need a proper date table in order for the time intelligence functions to work.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Denis, What i was trying to do is start my rolling 6 months from date index number 25 which is Feb 2017 and ignore all dates before this date..... Is this possible?

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey Anonymous ,

 

I don't know what you mean with index number 25 as that's also not in your file.

But you can set the date in the measure above. Instead of "MAX('DateTable'[Date])" you can also just write "DATE( 2017, 2, 25)" as start date.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis