Forum Discussion

apc_123's avatar
apc_123
Helper I
5 years ago
Solved

MTD TODAY

Hola buenos dias   estoy intentando crear una medida que me calcule las ventas MTD hasta hoy   TOTALMTD(SUM(tabla1[venta]),tabla1[Fecha])   esta es la formula pero me interesa que se vea ha...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    apc_123 ,

     

    LYMTD QTY forced=
    var _max = date(year(today())-1,month(today()),day(today()))
    return
    if(max('Date'[Date])<=_max, CALCULATE(Sum('order'[Qty]),DATESMTD(dateadd('Date'[Date],-1,year)),'Date'[Date]<=_max), blank())
    //OR
    //CALCULATE(Sum('order'[Qty]),DATESMTD(dateadd('Date'[Date],-1,year)),'Date'[Date]<=_max)
    //TOTALMTD(Sum('order'[Qty]),dateadd('Date'[Date],-1,year),'Date'[Date]<=_max)

amitchandak's avatar
amitchandak
Super User
5 years ago

apc_123 , if you have selected a date this will take till that date. If you have not selected any date try like

 

MTD QTY forced=
var _max = today()
return
if(max('Date'[Date])<=_max, calculate(Sum('order'[Qty]),DATESMTD('Date'[Date])), blank())
//or
//calculate(Sum('order'[Qty]),DATESMTD('Date'[Date]),filter('Date','Date'[Date]<=_max))
//calculate(TOTALMTD(Sum('order'[Qty]),'Date'[Date]),filter('Date','Date'[Date]<=_max))

apc_123's avatar
apc_123
Helper I
5 years ago

And if i want calculate the previous year

I think i must calculate the var max_old, for example

max_Previous_Year = date(year(today()-1,month(today(),day(today())


is correct ?

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    apc_123 ,

     

    LYMTD QTY forced=
    var _max = date(year(today())-1,month(today()),day(today()))
    return
    if(max('Date'[Date])<=_max, CALCULATE(Sum('order'[Qty]),DATESMTD(dateadd('Date'[Date],-1,year)),'Date'[Date]<=_max), blank())
    //OR
    //CALCULATE(Sum('order'[Qty]),DATESMTD(dateadd('Date'[Date],-1,year)),'Date'[Date]<=_max)
    //TOTALMTD(Sum('order'[Qty]),dateadd('Date'[Date],-1,year),'Date'[Date]<=_max)