Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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. ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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's avatar
Anonymous
Not applicable
7 years ago

Anonymous thnks, but have the same result as I had befor in my first message 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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. 

    • v-xuding-msft's avatar
      v-xuding-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      Hi Anonymous ,

      Can you please attach a dummy file? Based on my test, the measure worked when I changed ALL to ALLEXCEPT.

      Measure = 
CALCULATE (
    SUM ( Table1[Billable] ),
        FILTER (
            ALLEXCEPT( Table1,Table1[GEC] ),
            Table1[Week] = SELECTEDVALUE ( Table1[Week] ) -1 &&
            YEAR ( Table1[Date] ) = SELECTEDVALUE ( Table1[Year] )
        )
)

      Best Regards,

      Xue

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.