Forum Discussion

pradeepyadav921's avatar
pradeepyadav921
Frequent Visitor
2 years ago
Solved

Finding two previous dates with current date

Hi everyone,

 

I have a dataset where I have a product and date now I have created a date picker now how to get previous two dates, as my final aim is to show the product and their data for the date I selected from the date picker and previous two dates also in a tabular format.

 

 

Need Help
  • Shreeram04's avatar
    Shreeram04
    2 years ago

    Hi pradeepyadav921 

     

    We can do this by using the DAX measure. Please refer to the measure and screenshot for your reference.

     

    1. Total Sales = SUM('Table (2)'[Sales])
     
    2. Total Sales Today and Previous 2 Days =
    VAR SelectedDate = SELECTEDVALUE('Table'[Date])
    RETURN
    IF(
        ISFILTERED('Table'[Date]),
        CALCULATE(
            [Total Sales],
            FILTER(
                ALL('Table'),
                'Table'[Date] >= SelectedDate - 2 && 'Table'[Date] <= SelectedDate
            )
        ),
        [Total Sales]
    )

     

    The selected date in the filter is 5/4/2023 it shows values for the selected and last 2 days.

     

    Did I answer your question? Mark my post as a solution! This will help others

    Thanks,

    Hari R

     

     

     

1 Reply

  • Shreeram04's avatar
    Shreeram04
    Resolver III
    2 years ago

    Hi pradeepyadav921 

     

    We can do this by using the DAX measure. Please refer to the measure and screenshot for your reference.

     

    1. Total Sales = SUM('Table (2)'[Sales])
     
    2. Total Sales Today and Previous 2 Days =
    VAR SelectedDate = SELECTEDVALUE('Table'[Date])
    RETURN
    IF(
        ISFILTERED('Table'[Date]),
        CALCULATE(
            [Total Sales],
            FILTER(
                ALL('Table'),
                'Table'[Date] >= SelectedDate - 2 && 'Table'[Date] <= SelectedDate
            )
        ),
        [Total Sales]
    )

     

    The selected date in the filter is 5/4/2023 it shows values for the selected and last 2 days.

     

    Did I answer your question? Mark my post as a solution! This will help others

    Thanks,

    Hari R