Forum Discussion
Active and Inactive customers
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
IF(DATEDIFF(SELECTEDVALUE(EDW_GIFTCARDS_CARDHOLDERS[TransactionDt]),EARLIER(EDW_GIFTCARDS_CARDHOLDERS[TransactionDt]),MONTH>6,"Inactive","Active"))
i need someting like above datediff for current date and previous date different is having >6 is active and < 6 is Inactive
amitchandak