Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cumulative Sales by Customer using Play Axis

Hi Everyone,   I posted a similar question a little while ago but never was able to get to a solution.  I am looking to show cumulative sales by customer since January 1, 2018 on a bar chart using ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , I think you have  to use an independent date table for the slicer on which play axis will run

     

    Example

     

    Cumulative Invoiced for PLAY =

    var _max = MAXX(allselceted(Date2) , Date2[Date])

    return
    CALCULATE(
    [Total Revenue $$$ (CAD)],
    DATESBETWEEN(
    CalendarDate[Date],
    MIN(CalendarDate[Date]),
    MAX(CalendarDate[Date])
    ) , CalendarDate[Date] <=_max
    )

     

    Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

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

Anonymous , I think you have  to use an independent date table for the slicer on which play axis will run

 

Example

 

Cumulative Invoiced for PLAY =

var _max = MAXX(allselceted(Date2) , Date2[Date])

return
CALCULATE(
[Total Revenue $$$ (CAD)],
DATESBETWEEN(
CalendarDate[Date],
MIN(CalendarDate[Date]),
MAX(CalendarDate[Date])
) , CalendarDate[Date] <=_max
)

 

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI