Forum Discussion
Active and Inactive customers
Hi all, I need active customers count and inactive customers count Active customers are within the 6 months and Inactive customers are +6months table A id date 1 1/1/2018 1 ...
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 this
IF(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