Help on Cumulative total and Shifting PQ to CQ

[vijay273162]

Hi Microsoft Team,

Please refer the link for SAMPLE . pbix file, You can download and refer dummy data used for Clalculation.

https://drive.google.com/file/d/1NKtywVBSzqyDpC2xEPAKQ3rFkt8qrj1v/view?usp=sharing

[v-yalanwu-msft · Accepted solution]

Hi, @vijay273162 ;

You could only create a measure as follow:

Measure =
CALCULATE (
    SUM ( 'Fact table - Sales'[Sales Amount] ),
    FILTER (
        ALLSELECTED ( 'Fact table - Sales' ),
        [Date] <= MAX ( 'calendar'[Date] )
            && YEAR ( [Date] ) = YEAR ( MAX ( 'calendar'[Date] ) )
            && QUARTER ( [Date] ) = QUARTER ( MAX ( 'calendar'[Date] ) )
    )
)

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vijay273162]

I need help to slice the cumulative sales table value by Region slicer. Can you help.

Below is the sample .pbix file download link

https://drive.google.com/file/d/1HEt9wc_lpqjh8qjThIvYvSpsHLwqxzkC/view?usp=sharing

[vijay273162]

Thanks for your reply and checking.

I'm able to find the answer on this issue.

Will connect back, if needed help with this sample.

[vijay273162]

Hi Ibendlin,

If you download that .pbix file, I have mentioned , to get the

1. measure for shiftin values from Q1 FY22 to Q1 FY23 ( where there is no sales ).

2. Then we need to find the cumulative for that Q1 FY23 value.

[lbendlin]

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

[lbendlin]

Thank you for providing the sample data.  It is not clear what you are trying to achieve. Are you asking for help to do Quarter over Quarter To Date comparisons?