Forum Discussion

Tine82's avatar
Tine82
Icon for Helper I rankHelper I
2 months ago
Solved

Help Needed: Displaying Previous and Next Week in Power BI Table Visual

Hello PBI Community, I'm currently facing a challenge in Power BI and would greatly appreciate your support as I'm a bit stuck. I have a Table Visual with the following data: Product Material No...
Need Help
  • v-sathmakuri's avatar
    v-sathmakuri
    1 month ago

    Hi Tine82 ,

     

    Thanks you for reaching out to fabric community.

     

    Thanks pankajnamekar25  and jgeddes  for the prompt response.

     

    Could you please check the provided solution and let us know if you have any further questions.

     

    Thanks!!

jgeddes's avatar
jgeddes
Icon for Super User rankSuper User
2 months ago

Something like these might work for you...

Measure (Previous Week) = 
CALCULATE(
    SUM('Table'[Order Qty]),
    FILTER(ALLEXCEPT('Table', 'Table'[Product], 'Table'[Material No]), 'Table'[Week] = SELECTEDVALUE('Table'[Week]) - 1)
)

 

Measure (Next Week) = 
CALCULATE(
    SUM('Table'[Order Qty]),
    FILTER(ALLEXCEPT('Table', 'Table'[Product], 'Table'[Material No]), 'Table'[Week] = SELECTEDVALUE('Table'[Week]) + 1)
)