This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreGet Fabric Certified for FREE during AI Skills Fest. This week only. Secure your voucher now.
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?
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 23 | |
| 21 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 58 | |
| 55 | |
| 42 | |
| 26 | |
| 24 |