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)
johnt75's avatar
johnt75
Super User
4 years ago

Create a new table with the Category and the refresh date. You can then use RELATED or LOOKUPVALUE to get the target refresh date and do a datediff with today

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