Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Ignore the extra month added by time intelligence

Hello, I create a month-over-month measure from quick measures. It works, except it adds a future month, which I can't seem to filter out. How can I tell it to "ignore" February?

 

Need Help

7 Replies

  • mwegener's avatar
    mwegener
    Icon for Most Valuable Professional rankMost Valuable Professional
    6 years ago

    Hi Anonymous ,

     

    check this

     

    MoM =
VAR __MONTH =
    SUM ( 'Table'[Value] )
VAR __PREV_MONTH =
    CALCULATE ( SUM ( 'Table'[Value] ), DATEADD ( 'Calendar'[Date], -1, MONTH ) )
RETURN
    IF ( ISBLANK ( __MONTH ), BLANK (), __MONTH - __PREV_MONTH )

     

    Regards,

    Marcus

    Dortmund - Germany
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      If I understand this correctly, it looks like it will exclude blanks regardless of the month? Unfortunately I have "true" blanks in my data at a detail level and I want to keep those. I just want to ignore the "artificial" blanks. I guess I want it to do the filtering at the end, based on month, instead of whether is blank. Is there a way to apply the filter after all measures are computed?

      • mwegener's avatar
        mwegener
        Icon for Most Valuable Professional rankMost Valuable Professional
        6 years ago

        Can't the period be simply filtered accordingly?

  • mwegener's avatar
    mwegener
    Icon for Most Valuable Professional rankMost Valuable Professional
    6 years ago

    Hi Anonymous,


    is your problem solved?
    If we answered your question, please mark a post as solution, this will also help others.
    Please give Kudos for support.