Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi ,
I need to calculate current week ,previous week values . Have the below data . can anyone please help with dax ?
Category | total profit | Date |
Current week measure is working but im getting error for previous week. Having 2category records for previous week ,showing only one record.
@Jyo27 Try something like this:
Current Week Measure =
VAR __Date = TODAY()
VAR __CW = WEEKNUM(__Date)
VAR __Result = SUMX(FILTER('Table',WEEKNUM('Table'[Date]) = __CW),[total profit])
RETURN
__Result
Previous Week Measure =
VAR __Date = TODAY()
VAR __PW = WEEKNUM(__Date) - 1
VAR __Result = SUMX(FILTER('Table',WEEKNUM('Table'[Date]) = __PW),[total profit])
RETURN
__Result
Current Week Measure = VAR __Date = TODAY()
Instead of Today() can we pass dynamic date /week num ?
@Greg_Deckler can you please provide a solution for the above issue
var__date = Today()
instead of today can we pass dynamic week number ?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
60 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |