Forum Discussion

jmolina's avatar
jmolina
Frequent Visitor
4 years ago

Previous Year to Date until certain Date.

Hello everyone, along with saying hello, I hope you can help me with the following:   I have a dataset that has several million pieces of data, from which I need to calculate the YTD and Previous Y...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

What measures have you written?

jmolina's avatar
jmolina
Frequent Visitor
4 years ago

Ashish, i have this measures:

 

#MTD = CALCULATE([TOTAL SALES],
DATESBETWEEN(Calendar[Date],
FIRSTDATE(DATEADD(Calendar[Date],0,MONTH)),
IF(MONTH(MIN(Calendar[Date])) = MONTH(MAX(Calendar[Date])),EDATE(MAX(Calendar[Date]),0), LASTDATE(DATEADD(Calendar[Date],0,MONTH)))))

 

#MTD-1 = IF([TOTAL SALES] = BLANK(), BLANK(),
CALCULATE([Ventas Selecc],
DATESBETWEEN(Calendar[Date],
FIRSTDATE(DATEADD(Calendar[Date],-12,MONTH)),
IF(MONTH(MIN(Calendar[Date])) = MONTH(MAX(Calendar[Date])),EDATE(MAX(Calendar[Date]),-12), LASTDATE(DATEADD(Calendar[Date],-12,MONTH))))))

 

The MTD-1 It must meet the same conditions as the "New Measure" you gave me for the Previous YTD.

  • jmolina's avatar
    jmolina
    Frequent Visitor
    4 years ago

    Asish, any idea?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    I have off this thread for a while.  Shar some data, describe the question and show the expected result.

  • jmolina's avatar
    jmolina
    Frequent Visitor
    4 years ago

    I cannot find a solution,  i just re devolped everything, and calculate " PER CATEGORY" then just SUM by part, so in that way i can handle the date problem.

     

    Regards