Forum Discussion
Previous Week values (not summarized)
Hi! Need a help with this case please. I'm trying to get previous week data in the last column, and actually i got it, but it shows the summ of all GECs, and i need to split it GEC by GEC. ...
Anonymous
Use this DAX. Before using just shift your measure under another table
Modeling - Properties - Home Table - select other table than TTL_employees
test PrevWeek Bill HC = CALCULATE ( SUM ( Table1[Billable] ), FILTER ( ALLEXCEPT( Table1,Table1[GEC] ), Table1[Week1] = SELECTEDVALUE ( Table1[Week1] ) -1 && YEAR ( Table1[Date] ) = SELECTEDVALUE ( Table1[Year] ) ) )
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Proud to be Datanaut!
no, I haven't. you mean to replace FILTER () part with quick mesure filter?
mussaenda
Community Champion
Community ChampionSorry, my response is not suitable to your need. Apologies.
Have you tried to remove ALL from the code?
yes. and I got the empty last column :(