Forum Discussion

Anshu_Joshi's avatar
Anshu_Joshi
Frequent Visitor
3 years ago

Current Month vs Previous Months

Hi Team,  Here is the task, I have 6 Months data, January to June, I have to show the number of customers in the current month vs total number of customers from January to May. I'm trying to create...
Need Help
Kishore_KVN's avatar
Kishore_KVN
Icon for Solution Sage rankSolution Sage
3 years ago

Hello Anshu_Joshi ,

 

I believe you are using Month from different table. If that is not the case, then your formula should work. I tried to create same measures at my end and they are working. Can you please share the same data and the outputs you are getting. 

 

In my case you can see below screenshots for excel calculation and Power BI outputs as well:

sum of sales from 1st Jan to 31 May in Excel is as below which is 7982:

Measure and output in Power BI are as below:

Current Month as per excel is 710:

Current Month as per Power BI:

 

If Previous Months DAX is not working then you can use it as below as well:

Sales Before Current Month = CALCULATE(SUM(Data[Sales]),ALL(Data),FILTER(Data,Data[Month]<MONTH(TODAY())))

 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

 

 

 

 

Anshu_Joshi's avatar
Anshu_Joshi
Frequent Visitor
3 years ago

Hello Kishore_KVN ,

Thank you for the reply.

 

Actually I'm having a date column from which I created a Month column.

I don't have numbers to sum but Customers name to count.

 

For the above Image I used this Measure: 

Current Month Total Customer = CALCULATE(COUNT('Customer list'[Customer Name]), FILTER(ALL('Customer list'), [Month] = MONTH(TODAY())))
and 
Previous Months Total Customer = CALCULATE(COUNT('Customer list'[Customer Name]), FILTER(ALL('Customer list'), [Month] < MONTH(TODAY())))