List of customers who haven't done any Transaction in compare to last month

[Dipakb]

Please suggest the formula which should correctly return the list of customers' name who did not make any transactions in the selected month compared to the previous month.

[Fowmy]

@Dipakb 

 Create the following measure, add your customers in a Table visual and include the mesure in the Visual filter and set it equal to 1, it should show you the customers who have sales in current month but no sales in previous month:

Missing Sales = 
 INT (
                [Sales Amount] = BLANK ()
                    && CALCULATE ( [Sales Amount], PREVIOUSMONTH ( 'Date'[Date] ) ) <> BLANK ()
            )

[FreemanZ]

hi @Dipakb 

check this:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Measure-to-show-current-new-recovered-and-los...