Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Create a calculated row

I have a "User registration date" and "product purchase date" in my dataset... Simply what I want to do is; when I change date range in slicer, how many of them have become members between these d...

Need Help

v-lili6-msft

6 years ago

hi, Anonymous

Use DISTINCTCOUNT in the formula

Result 3 = var _fromdate=CALCULATE(MIN(Sheet1[New Transaction Date]),ALLSELECTED(Sheet1)) 
var _enddate=CALCULATE(MAX(Sheet1[New Transaction Date]),ALLSELECTED(Sheet1))  return
CALCULATE (
    DISTINCTCOUNT( Sheet1[WalletID] ),
    FILTER (
        Sheet1 ,
        Sheet1[New Wallet Createddate] >= _fromdate 
            && Sheet1[New Wallet Createddate] <= _enddate
    )
)

Regards,

Lin

Anonymous

Not applicable

6 years ago

Hi Mariusz , Im so sorry, I updated my previous post. Please kindly check it again.