Forum Discussion
DAX Time Intelligence Week
Hi All, I have a question related to DAX on how to dynamicaly pass the filter selected value indide a measure. consider the below code YTD Target v1 = VAR DW = SWITCH(TRUE(),SELECTEDVA...
You need to use a YearWeek value, or better yet a Date value (divided by 7 if you want), otherwise your logic will break at the year cutover.
Best solution is to have a Calendar table with yearweek column.