Show Days Before Or After A Selected Date - Advanced Power BI Visual Techniques

DAX DAX Calculations
1

Hi,

I have watched the training module on how to show data before or after a certain date.

I now need to show a total value of the selected values only

Power%20bi%20total%20for%20selected%20values
Power%20bi%20total%20for%20selected%20values987×564 38.5 KB

2

Try the below logic…

image
image.png773×750 56.7 KB 

Sales From Selected Date = 
VAR SelectedDate = CALCULATE( MAX( 'Selection Date'[Date] ), ALL( Dates ) )

RETURN
IF( HASONEVALUE( Dates[Date] ),
    IF( AND( MAX( Dates[Date] ) > SelectedDate - [Day Number] , MAX( Dates[Date] ) <= SelectedDate ),
        [Total Sales],
            BLANK() ),
                CALCULATE( [Total Sales], 
                    FILTER( ALL( Dates ),
                    Dates[Date] > SelectedDate - [Day Number] &&
                    Dates[Date] <= SelectedDate ) ) )

This should do it I believe

Thanks
Sam

3

Thank you so much. Solution works perfect.