Forum Discussion

ajitsahoo8338's avatar
ajitsahoo8338
Helper III
1 year ago

Need Help with this logic

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

Need Help
Show and Tell

1 Reply

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    1 year ago

    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]
    )