Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everybody, i'm trying to convert a SQL query that looks like this to DAX but without a success:
CASE WHEN [T.Time_Week] > DATEADD(WEEK, DATEDIFF(WEEK, 0, GETDATE()) - 1, 0) THEN '3: Current week and forward'
WHEN [T.Time_Week] >= DATEADD(WEEK, DATEDIFF(WEEK, 0, GETDATE()) - 10, 0) THEN '2: Last 10 Weeks'
ELSE '1: Before Last 10 Weeks' END AS Time_Window
Can you help me with this please ?
Many thanks
well the main question is how to convert into DAX the SQL "CASE WHEN" query, and then this part of the query also is not clear to me: DATEADD(WEEK, DATEDIFF(WEEK, 0, GETDATE()) - 10, 0) THEN '2: Last 10 Weeks'
What specific piece are you having trouble with? Can you supply sample data?
User | Count |
---|---|
100 | |
89 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |