Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All,
I am working on a power bi report and i have bugsfound for each week. I need to get previousweeknumber and then its bugs so that i can calculate WoW. Below is the summary,
Currently i have this
WeekNbr BugsFound
34 10
35 20
36 30
With formula in power bi, i calculated PrevWeekNbr
WeekNbr BugsFound PrevWeekNbr
34 10 33
35 20 34
36 30 35
What i need is (imagine week 33 bugs are 5)
WeekNbr BugsFound PrevWeekNbr PrevWeekBugs
34 10 33 5
35 20 34 10
36 30 35 20
I tried different formulas for new measure but did not get lucky. Any ideas ??
Solved! Go to Solution.
Hi Sai
How about this one:
PrevWeeksBugs2 = LOOKUPVALUE(Bugs[BugsFound];Bugs[WeekNbr];Bugs[PrevWeekNbr])+0
It is not a very nice solution I admit, someone might provide a better one.
JJ
Hi
Creating a colmn with this forumla might help (you might have to replace the semicolons with commas):
PrevWeekBugs = SUMX( FILTER( Bugs; Bugs[WeekNbr] = EARLIER(Bugs[PrevWeekNbr]) ) ;Bugs[BugsFound] )+0
Hope this helps
JJ
Hello JJ,
Thanks for your quick response and solution
I am using directquery models and i think thats the reason i am getting below error while using below logic.
Function 'SUMX' is not allowed as part of calculated column DAX expressions on DirectQuery models.
Any ideas on this.
Thanks,
Sai
Hi Sai
How about this one:
PrevWeeksBugs2 = LOOKUPVALUE(Bugs[BugsFound];Bugs[WeekNbr];Bugs[PrevWeekNbr])+0
It is not a very nice solution I admit, someone might provide a better one.
JJ
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |