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.
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 =
[Sales Amount] = BLANK ()
&& CALCULATE ( [Sales Amount], PREVIOUSMONTH ( 'Date'[Date] ) ) <> BLANK ()
⭕ Subscribe and learn Power BI from these videos ⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.