Forum Discussion
Active and Inactive customers
missed [ ]
sumx(summarize(calculatetable(TableA,DATESINPERIOD( DATE[DATE], MAX( DATE[DATE] ), -6, MONTH )),
TableA[ID] , "_active",distinctcount(TableA[ID])),[_active])
amitchandak
can you please check my attachment it getting blank.
https://drive.google.com/open?id=15iTjxrsEJVvzBeczc1d9ByvyNF178ZUi
Here I need the count of active and count of inactive customers based on the date selected in the slicer I need to calculate active users based on a 6month window. It would have to go back 6months from month selected date in a slicer.
Date was having timestamp. Created date from that and join. Check now
https://www.dropbox.com/s/lvppqvumfda3ihd/activecustomer.pbix?dl=0
A formula with datediff with earlier function Dax because if I selected active in slicer the count should be an active customer and if I selected inactive it display inactive. Is it possible to do that ?? amitchandak
something like thisIF(DATEDIFF(SELECTEDVALUE(EDW_GIFTCARDS_CARDHOLDERS[TransactionDt]),EARLIER(EDW_GIFTCARDS_CARDHOLDERS[TransactionDt]),MONTH>6,"Inactive","Active"))Did not got the last update, if you are looking for slicer to choose measure refer