Display Last Weeks Data Dynamically Based On Date selection in slicer

[Aradhika]

Hi Team,

I have requirement in my project such as if i select "OrderDate"
From Slicer then based on that date last week sales data should populate in visual.
Example:
Suppose:
If i select 4/12/2020 in slicer then last week data should populate from that date.
If i select 11/22/2019 in slicer then last week data should populate from that date.

Columns i have is Order_date, Sales - Only two columns i am using...

I've created a couple of DAX Measures. However, that measure is calculating all weeks inspite of 1 Week.

Thanks for any help you can provide. You've been great.
AD

 

[JustynaMK]

Hi Aradhika,

To retrieve the total in a single card you can use this adjusted version:

mSumOrders = 
    var SelectedDate = SELECTEDVALUE(Orders[OrderNewDate])
    var NewDate = DATEADD(Orders[OrderNewDate], -3, MONTH)
return
    CALCULATE(
        SUM(Orders[Sales]),
        FILTER(ALL(Orders[OrderNewDate]), 
            Orders[OrderNewDate] < SelectedDate &&
            Orders[OrderNewDate] >= NewDate)
    )

Let me know if that works for you.

 

[Aradhika]

Hi Aradhika,

To retrieve the total in a single card you can use this adjusted version:

mSumOrders =
    var SelectedDate = SELECTEDVALUE(Orders[OrderNewDate])
    var NewDate = DATEADD(Orders[OrderNewDate], -3, MONTH)
return
    CALCULATE(
        SUM(Orders[Sales]),
        FILTER(ALL(Orders[OrderNewDate]),
            Orders[OrderNewDate] < SelectedDate &&
            Orders[OrderNewDate] >= NewDate)
    )

Let me know if that works for you.

 

[Aradhika]

Hi JustynaMK,

Sorry for delay in Reply.

It is working as expected... Again thank you for ur help and time...

Regards,
Aradhikar