Hi all. I am struggling with calculating previous workday sales. I have 2 sales tables (from different ERPs) which I summarize into one sales total measure by branch location. No problem calculating and filtering by month. However, I need to show a previous days sales amount column. Below is my summary sales calculation. The problem is I have 2 different dates (1 in each table) so I when I use one of the dates in the previous day calculation the other group shows total for the month and visa versa.
I just need the summary sales for the prior work day. In my date table I have a “Isworkingday” column but it is not working. Thanks!
Summary Sales =
var dwsales = SUMX(fact_DW_DailySalesSummary,fact_DW_DailySalesSummary[Sales])
var s2ksales = SUMX(‘fact_Sales Details’,‘fact_Sales Details’[Qty Ship]*‘fact_Sales Details’[Price])