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.

     

leebm's avatar
leebm
Regular Visitor
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.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi leebm ,

 

Could you be able to show a pbxi file?

I am looking for similar solution, however does not get it yet.

 

Hope it is Ok to create a new post , and invite you for a answer. 😉

Best regards,

Yuqi