Need Help with this logic

[ajitsahoo8338]

Hello Everyone, I need help with this.

I have a date in my table, with dates ranging from 2019 to today. My requirement is to display Measure1 for dates from the previous Sunday to the previous Saturday, and Measure2 for all other dates.

How can I achieve this?

Thank You,
Ajit

[bhanu_gautam]

@ajitsahoo8338 

Create a calculated column to identify the week range:
DAX
WeekRange =
VAR CurrentDate = 'Table'[Date]
VAR PreviousSunday =
IF(
WEEKDAY(TODAY(), 2) = 7,
TODAY() - 7,
TODAY() - WEEKDAY(TODAY(), 2)
)
VAR PreviousSaturday = PreviousSunday + 6

Create a measure to display Measure1 or Measure2 based on the week range:
DAX
DisplayMeasure =
IF(
MAX('Table'[WeekRange]) = "PreviousWeek",
[Measure1],
[Measure2]
)