Forum Discussion

jjkmd's avatar
jjkmd
Helper I
6 years ago
Solved

Debug help please

I have simplified my table to one value (Charge90) per month.  I have a measure that shows me the rolling 12 total.   Rolling individual = sumx(DATESINPERIOD(PostMonthly90[Month_Post],LASTDATE(Post...
rolling 12
  • TomMartens's avatar
    TomMartens
    6 years ago

    Hey,

     

    without data that allows to recreate the observation that you describe, it's almost impossible to provide any help for debugging the issue (at least I'm not able to provide any help).

     

    As far as I can see, you are using DATESINPERIOD and LASTDATE. Both of  these DAX functions can be considered as one of the Time Intelligence (https://dax.guide/ and look for Time Intelligence, this is something different than Date and Time functions) functions. It's a good practice to use a dedicated calendar table without any missing dates, and link this table to all the other tables like:

    PostMonthly90

     

    Regards,

    Tom

TomMartens's avatar
TomMartens
Super User
6 years ago

Hey,

 

without data that allows to recreate the observation that you describe, it's almost impossible to provide any help for debugging the issue (at least I'm not able to provide any help).

 

As far as I can see, you are using DATESINPERIOD and LASTDATE. Both of  these DAX functions can be considered as one of the Time Intelligence (https://dax.guide/ and look for Time Intelligence, this is something different than Date and Time functions) functions. It's a good practice to use a dedicated calendar table without any missing dates, and link this table to all the other tables like:

PostMonthly90

 

Regards,

Tom

jjkmd's avatar
jjkmd
Helper I
6 years ago

Thank you Tom, i'll do a different post with sample data that should hopefully help.

 

Thanks!