Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone,
I´m trying to get the new number of new custumers per month.
I have a date table and a tables with the number od costumers per day
so i have on the main table:
january: 2500 costumers
february: 3500 costumers
march: 4000 costumers
and so on.
I need a dax formula that give me the new costumers i have in february (1.000 new costumers) in March (500 new costumers), and so on.
Can anyone help me?
Thanks
JanCount =CALCULATE(DISTINCTCOUNT('Table'[UniqueCustomerID]), 'Table'[Date].[Month] = "1")
Make one for each month then you can add or subtract or whatever you need to do.
MonthChange = [JanCount]-[DecCount]