Commulative with Month Slicer

Question

Dear Helper,&nbsp;i have two tables Calendar and Sales, i need to get sales amount Commulative and want display on Column chart.Calendar table:and Sales table:&nbsp;Measures i wrote:&nbsp;&nbsp;Measure Sales =var min_date=CALCULATE(MIN('Calendar'[Date]),ALL('Calendar'))returnCALCULATE(SUM('Table'[Sales]),DATESBETWEEN('Calendar'[Date],min_date,MAX('Calendar'[Date])))&nbsp;i have Month slicer and Column chart on my report.Whenever i select slicer month May-2024, i want to get Column from May-2024 to Jan 2024.&nbsp;&nbsp;Whenever i select slicer month Apr-2024, i want to get Column from Apr-2024 to Jan 2024.&nbsp;&nbsp;&nbsp;&nbsp;Whenever i select slicer month March-2024, i want to get Column from March-2024 to Jan 2024.&nbsp;&nbsp;Whenever i select slicer month Feb-2024, i want to get Column from Feb-2024 to Jan 2024.&nbsp; and so.&nbsp;How can i achive this.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

lbendlin · Answer

Have you considered using the Quick Measures?&nbsp; There the pattern is called "Running Total"

jyaul1122 · Answer

I tried with Quick Measure but it does not work. Please let me know if you have another idea.Thanks

lbendlin · Answer

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

jyaul1122 · Answer

lbendlin&nbsp;For your information, sales table:TableDateSales01-Jan-20241001-Feb-20241501-Mar-20242001-Apr-20242501-May-202430&nbsp;and calendar table: CALENDARAUTO(12)&nbsp;the measure , I am using:&nbsp;Measure&nbsp;Sales =var&nbsp;min_date=CALCULATE(MIN('Calendar'[Date]),ALL('Calendar'))returnCALCULATE(SUM('Table'[Sales]),DATESBETWEEN('Calendar'[Date],min_date,MAX('Calendar'[Date])))

anonymous · Answer

Hi&nbsp;lbendlin&nbsp;,
Thanks for your quick response.
Hi&nbsp;Jyaul1122&nbsp;,
Please refer to my pbix file to see if it helps you.
Create a measure.
MeasureSales =
VAR _1 =
    CALCULATE (
        SUM ( 'Table'[Sales] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Date] &lt;= SELECTEDVALUE ( 'Calendar'[Date] )
                &amp;&amp; 'Table'[Date] &lt;= SELECTEDVALUE ( 'Table'[Date] )
        )
    )
VAR _2 =
    SELECTEDVALUE ( 'Calendar'[Date] )
RETURN
    IF ( _2 &gt;= MAX ( 'Table'[Date] ), _1, BLANK () )

&nbsp;
How to Get Your Question Answered Quickly - Microsoft Fabric Community
&nbsp;
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
&nbsp;
Best RegardsCommunity Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;

Forum Discussion

Commulative with Month Slicer

6 Replies

Related content

Sorting X- axis based on Month-Year slicer selection

Filter Months from Month Slicer

Previous month selected automatically from drop-down slicer

Trailing Month Slicer

Month to Month Flow Calculation