Difference in total value from last week to current week

[Anonymous]

Hello, 

I am attempting to calculate the total value of a category up until the previous week (cut off on the friday of that week) and then have another column that shows the current count at that point in time. So i can then total the difference to utilize conditional formatting to show the change on a rolling basis. I have a date table with week numbers and a table with the values. Is this possible with DAX?

Category	Total Amount up until last week (excluding current week)	Total Amount current (Including current week)	Difference
A	12	15	3
B	11	8	-3
C	5	7	2
D	1	0	-1

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but check the below picture and the sample pbix file's link down below.

All measures are in the sample pbix file.

Link to the pbix file