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.

 

vinaybangari's avatar
vinaybangari
Frequent Visitor
7 years ago

Hi Leebm,

 

Can you please post your complete DAX expression for previous YTD, MTD & QTD periods

  • vinaybangari's avatar
    vinaybangari
    Frequent Visitor
    7 years ago

    This is Previous YTD works fine: Prev YTD = CALCULATE([Current YTD],SAMEPERIODLASTYEAR('Calendar'[Date]))

     

    Prev MTD Period Balance = CALCULATE([Period Balance],DATEADD('Calendar'[Date],-1,MONTH))