Forum Discussion

Nagesh20's avatar
Nagesh20
Icon for Helper I rankHelper I
2 years ago
Solved

Seperate value from running total measure based on max date

Hi all,   I am able to calculat the running total based on max date. I would like to get final number from running total measure based on the max date. I have attached below example (i.e . Total va...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    Nagesh20 ,  Create a measure using your measure

     

    if(Max(Calendar[Date]) = maxx(filter(allselected(Table), Table[Product] = max(Table[Product]) ), Table[Date]) , [Cumulative (running total measure) ], blank()) 

     

    or

     

     

    Measure =
    var _max =maxx(filter(allselected(Table), Table[Product] = max(Table[Product]) ), Table[Date])
    return
    Switch ( true(),
    Max(Calendar[Date]) = _max , [Cumulative (running total measure) ],
    Max(Calendar[Date]) < _max , 0 ,
    blank())

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

Nagesh20 ,  Create a measure using your measure

 

if(Max(Calendar[Date]) = maxx(filter(allselected(Table), Table[Product] = max(Table[Product]) ), Table[Date]) , [Cumulative (running total measure) ], blank()) 

 

or

 

 

Measure =
var _max =maxx(filter(allselected(Table), Table[Product] = max(Table[Product]) ), Table[Date])
return
Switch ( true(),
Max(Calendar[Date]) = _max , [Cumulative (running total measure) ],
Max(Calendar[Date]) < _max , 0 ,
blank())

  • Nagesh20's avatar
    Nagesh20
    Icon for Helper I rankHelper I
    2 years ago

    amitchandak 

    Awesome 🙂

    2nd formula is working

     

    Thanks a lot

     

    • Nagesh20's avatar
      Nagesh20
      Icon for Helper I rankHelper I
      2 years ago

      Hi amitchandak 

       

      I am not able to get the total when applying the second formula that you suggested. Could you please advice how to get the total for this formula in the table. 

       

      Max =
      Var _max=maxx(filter(allselected(Table1), Table1[Product] = max(Table1[Product]) ), Table1[Date])
      return
      Switch ( true(),
      Max(Calender[Date]) = _max ,[Cumulative],
      Max(Calender[Date]) < _max , 0 ,
      blank())