Hi PBI people
I have two tables, one for “preinvoice” and one for “sales”, which are connected to the date table.
I have two measures from these tables called Preinvoice revenue and Sales Actual.
Assume its November, and today is 13/11/2020. I need to combine values in the “sales actual” column only up to 12/11/2020, and add take two values (the 13th and 14th of November from the “preinvoice revenue” and make one new column.
I’m totally stuck on how to do this!
I intentionally need to drop the $25K sales value from 13/11/2020 because this is an incomplete sales total (wont be complete until close of business that day.)PBI quest…xlsx (10.4 KB)
After I’ve combined them I need to do a cumulative plot of the data, that bit I can do, but stumped on getting the columns combined…!