Forum Discussion
Previous Week values (not summarized)
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!
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!
Anonymous thnks, but have the same result as I had befor in my first message
Anonymous
Check this file
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!Anonymous I see. In your example you have different dates for each row, in mine - I have different data for each GEC in the same day. Thats why your file works perfect, but it doesn't fit to my case.