Difference in same measure

[afleiderman1]

Hi everyone I have the following problem,

I have the following problem

I have one measure where I put put my values 

sales amount

I have one value I in my column date for week begins 

And for my row I have one value which is customer name

So I have for example the following table

I also have emplyoeed on my row

Name                  employeed id        Week Begins   6/1/2023                6/7/2023             total

Jeff Durand                XZW4                       100                 50                                        150

Elliot Jamal                WER5                        20                     40                                      60 

My question is I want the difference between what was sold between 6/7 and 6/1

Name                   Week Begins   6/1/2023                6/7/2023        difference         total

Jeff Durand                                 100                         50                              -50                    150

Elliot Jamal                                  20                       60                          20                  60 

But I am not sure how to create this as a measure and have a table like the one above.

They both come from the same measure sales amount. 

Please help.

[afleiderman1]

Hi I got one more quick question what would the relation between the wow column 1 and the week begin date

I tried doing something similar but got this

[amitchandak · Accepted solution]

@afleiderman1 , Please find the file. The file assumes that at least 2 weeks are selected. The diff calculation can work even if one week is selected, but I suppressed it.

Table

Measure
Measure = SWITCH(TRUE(),
Max(WOW[Column1]) ="Actual", [Net],
if(ISBLANK([This Week]) || ISBLANK([Last Week]), BLANK(), [This Week] -[Last Week]))

If needed consider an independent table when one week is selected and you want to display more than one week

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI