Total sales + Relative Date + Show sales for all employees

[H_insight]

Hi,

I have a relative Date filter on a page and it's filtering my table per last week's data. I am trying to show last week's data and show all employees that didn't have sales in that week too.

Simple measure:

Total Sales = SUM(Sales[SalesAmount])

Current view:

Expected View:

Thanks

[amitchandak]

@H_insight , You can use a week behind measure

week behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-7,DAY))

Also check

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8

[H_insight]

Hi @amitchandak 

I have a relative date slicer to select the target week. So it's already filtering the data. What I want is to get all sales even if null/zero/blank for all employees.

Sample File

Thanks

[v-xiaotang · Accepted solution]

Hi @H_insight 

Thanks for reaching out to us.

Please try this,

Best Regards,

Community Support Team _Tang

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