Forum Discussion

jhayes0128's avatar
jhayes0128
Frequent Visitor
4 years ago

Play Axis - Cumulative Total Within Selected Date Range

I have a requirement where users want to see daily sales growth by day over a given timeframe. So the user selected 'October 2021' and they can see how sales grow starting from 0 on October 1st.

 

I cannot use ALL since that returns all records from before October. Using any kind of MIN or FIRSTDATE is affected by the play axis I'm using to visualize the growth.

 

How can I make a cumulative measure for the selected date range the user selected, while ignoring the day-by-day increments play axis custom visual performs?

Need Help

2 Replies

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

    jhayes0128 , Try a new measure like

     

    Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi jhayes0128 

    Could you share a sample file or some sample data? and it would be nice if you can describe the desired result based on an example. Thanks.

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.