topic Number of Customers with Growth in DAX Commands and Tips

Number of Customers with Growth

Anonymous — Wed, 23 Feb 2022 12:59:56 GMT

Gentlemen, I need help again, I would like to measure in a certain period, how many times a customer had a drop in billing compared to the previous month, Ex:

Client Month %Current Month x Previous Month

bakery Jan -15%

bakery Feb -12%

bakery Mar 5%

In the example above, I would have a measure for the bakery customer, informing that he had 2 (two) months with which billing drop compared to the previous month!!!

Re: Number of Customers with Growth

amitchandak — Wed, 23 Feb 2022 13:27:15 GMT

Anonymous , Assume you have Billing measure

Billing % =

divide([Billing], calculate([Billing], allselected()) )

Then this month vs Last month , date table time intelligence

MTD Sales = CALCULATE([Billing %],DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE([Billing %],DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE([Billing %],previousmonth('Date'[Date]))

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA

Re: Number of Customers with Growth

Anonymous — Wed, 23 Feb 2022 15:21:07 GMT

Thanks for the quick response, but in fact I already have the evolution calculation in relation to the previous month, what I would need was to analyze based on this calculation, count in a certain period, 3 months for example, how many times we had a drop in evolution! !!

Re: Number of Customers with Growth

amitchandak — Wed, 23 Feb 2022 16:23:17 GMT

Anonymous , check if rolling 3 can help

Rolling 3 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,MONTH))

Rolling 3 before three= CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],eomonth(MAX('Date'[Date ]),-3),-3,MONTH))

Re: Number of Customers with Growth

johnt75 — Wed, 23 Feb 2022 16:48:35 GMT

I think a SUMX over a summary table would give you what you need

Num months with reduction =
CALCULATE (
SUMX(
   ADDCOLUMNS( SUMMARIZE( Customer, Customer[Customer Name], 'Date'[Year Month] )
      "@monthly change", [Month on Month Change]
   ),
   IF ( [@monthly change] < 1, 1 )
),
DATESBETWEEN( 'Date'[Date], DATE( YEAR( TODAY() ), MONTH( TODAY() ) - 3, 1 ), TODAY() )
)