Forum Discussion

leebm's avatar
leebm
Regular Visitor
10 years ago
Solved

Compare MTD with previous period

  Hi, I want to compare actual sales (running value) with sales in the same month last year. This should be shown in a Table and grouped by sales representative. I have a fact table with the sales ...
Need Help
  • leebm's avatar
    leebm
    10 years ago

    I finally solved it: I filter my measure with the datesbetween function. I created a measure for the beginning of the month last year (eomonth function) and another for the actual date (=EDATE(TODAY);-12)

    This way I have always the actual month compared to the month last year, even if the month is not yet finished.

     

ako's avatar
ako
Regular Visitor
9 years ago

Hi leebm!

 

I have the exact same problem. Could you please explain the solution more presis for me?  (I'm a slow learner :)

jbjs5820's avatar
jbjs5820
Icon for Helper I rankHelper I
9 years ago

Could you insert the total formula?

 

  • Sachet_716's avatar
    Sachet_716
    Icon for Helper I rankHelper I
    8 years ago

    Hi!  

     

    Were you able to figure this out? Can you share the measure please? Been searching for this function and it's a show stopper for me, can't go ahead without completing this. thank you in advance! :)