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 ...
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