Forum Discussion

Justas4478's avatar
Justas4478
Post Prodigy
4 years ago
Solved

Category with specific dates

Hello I am trying to create a measure that checks weeks left to refresh for specific category in Level5 column. This is the table.   This is Weeks to refresh measure.    I am trying to modify...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    Ah, OK. Try something like

    Weeks to refresh =
var currentCategory = SELECTEDVALUE('Table'[Category 5])
var refreshDate = SWITCH( currentCategory,
   "Open", DATE(2022, 7, 25),
   "Female", DATE(2022, 6, 20)
)
return DATEDIFF( TODAY()-1, refreshDate, WEEK)
Justas4478's avatar
Justas4478
Post Prodigy
4 years ago

Due to Live connection method I am only able to use measures. I cant use calculated columns or create tables.

johnt75's avatar
johnt75
Super User
4 years ago

Ah, OK. Try something like

Weeks to refresh =
var currentCategory = SELECTEDVALUE('Table'[Category 5])
var refreshDate = SWITCH( currentCategory,
   "Open", DATE(2022, 7, 25),
   "Female", DATE(2022, 6, 20)
)
return DATEDIFF( TODAY()-1, refreshDate, WEEK)