Forum Discussion

Wiene24's avatar
Wiene24
Icon for Helper II rankHelper II
7 years ago

EOMONTH and SAMEPERIODLASTYEAR

Hi,   I am currently calculating the total up to last month by using the following formula:   Omzet tm vorig maand = CALCULATE(TOTALYTD([Totaal omzet];FILTER(ALLSELECTED('Datumtabel laadmeter'[D...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Wiene24 ,

I'd like to suggest you to use date function manually define filter range instead of use time intelligence function.

Time Intelligence "The Hard Way" (TITHW)

Regards,

Xiaoxin Sheng

  • Wiene24's avatar
    Wiene24
    Icon for Helper II rankHelper II
    7 years ago

    Hi Anonymous,

     

    The problem is that I can't work with MAX, because we have orders in the future.

    With the year it could work because my date table is only untill the end of 2019.

    But for the month MAX is maybe october or november, so that will return a different value.

    Is there a way I can use EOMONTH in the TITHW?

     

    Kind regards,

     

    Tim Wijnen 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      HI Wiene24 ,

      Can you please share some sample data and expected result for test?

      Regards,

      Xiaoxin Sheng