How to get customers have no Sales for three previous months
I have two tables CustInvoiceJour , CustInvoiceTrans are connected by the InvoiceId field in both tables. I added a slicer for InvoiceDate from the CustInvoiceTrans table. I want to identify customers who have no sales for three previous months from the date selected in the slicer. LineAmount is the column for sales amount. InvoiceAccount represents the customer number. DeliveryName is the customer name. InvoiceDate is the sales date.
Forecast value
I am trying to find out the forecast alue for the next dates using balow formula but after applying the forecast value it not showi n the next date value it showing collection values dax code Forecast 11 = VAR CurrentMonth = MONTH(MAX('Table'[Date])) VAR CurrentYear = YEAR(MAX('Table'[Date])) VAR LastDateOfMonth = CALCULATE(MAX('Table'[Date]), ALL('Table'), 'Table'[Date] >= DATE(CurrentYear, CurrentMonth, 1), 'Table'[Date] <= EOMONTH(MAX('Table'[Date]), 0)) VAR RemainingDays = LastDateOfMonth - MAX('Table'[Date]) + 1 RETURN IF(ISBLANK(SUM('Table'[Collection])), BLANK(), SUM('Table'[Collection]) * RemainingDays)
