cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gustavo468
Regular Visitor

Calculate Sum with last two date Selected in Slicer

Dear All, I´m new here and I´m new with Power BI.

 

I´m making my first dashboard and I have the following problem.

 

In my dashboard, I have a Slicer with date and that slicer control the Sales ammount (Sales[Ammount]).

 

I want to get the difference between these two dates selected in this slicer no matter if this are consecutive or not.

gustavo468_0-1659741103006.png

 

Is it possible ?

 

Thanks




1 ACCEPTED SOLUTION

Hi @gustavo468 ,

You can create a measure as below to get it, please find the details in the attachment.

Difference = 
VAR _maxdate =
    CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table'[Date] ) )
VAR _secondmdate =
    CALCULATE (
        MAX ( 'Table'[Date] ),
        FILTER ( ALLSELECTED ( 'Table'[Date] ), 'Table'[Date] < _maxdate )
    )
VAR _mamount =
    CALCULATE (
        SUM ( 'Table'[Amount] ),
        FILTER ( 'Table', 'Table'[Date] = _maxdate )
    )
VAR _smamount =
    CALCULATE (
        SUM ( 'Table'[Amount] ),
        FILTER ( 'Table', 'Table'[Date] = _secondmdate )
    )
RETURN
    _mamount - _smamount

yingyinr_0-1660022824836.png

If the above one is not working for you, please provide some sample data(exclude sensitive data) with Text format and your expected result with special examples and screenshots. It is better if you can provide me a simplified pbix file. Thank you.

Best Regards

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

View solution in original post

3 REPLIES 3
gustavo468
Regular Visitor

@yingyinr ,that´s work for me, Thank so much !!!!!

gustavo468
Regular Visitor

Sorry, the difference between the ammount sales for those dates. Thanks

Hi @gustavo468 ,

You can create a measure as below to get it, please find the details in the attachment.

Difference = 
VAR _maxdate =
    CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table'[Date] ) )
VAR _secondmdate =
    CALCULATE (
        MAX ( 'Table'[Date] ),
        FILTER ( ALLSELECTED ( 'Table'[Date] ), 'Table'[Date] < _maxdate )
    )
VAR _mamount =
    CALCULATE (
        SUM ( 'Table'[Amount] ),
        FILTER ( 'Table', 'Table'[Date] = _maxdate )
    )
VAR _smamount =
    CALCULATE (
        SUM ( 'Table'[Amount] ),
        FILTER ( 'Table', 'Table'[Date] = _secondmdate )
    )
RETURN
    _mamount - _smamount

yingyinr_0-1660022824836.png

If the above one is not working for you, please provide some sample data(exclude sensitive data) with Text format and your expected result with special examples and screenshots. It is better if you can provide me a simplified pbix file. Thank you.

Best Regards

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

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.