Forum Discussion

united2win's avatar
united2win
Helper III
3 years ago
Solved

DAX Formula Help

Hi, I have the following table of customer's and revenue dates. I would like to create DAX calculated column that tags the customer as 'New' when there is no revenue reported in the previous month. ...
Need Help
Show and Tell
  • vanessafvg's avatar
    vanessafvg
    3 years ago

    sorry for the delay in responding.

     

    you could try something like this

     

    New Customer =
    var maxdate = PREVIOUSMONTH(NewCustomer[RevenueDate])
    return if(maxdate, BLANK(),"New")
  • Thomas_Daubert's avatar
    Thomas_Daubert
    3 years ago

    hello,

    I did it with this formula : 

     
    new =
    var mois_prec = DATEADD(Sheet1[Revenue Date], -1, MONTH)
    return
        if(
            CALCULATE(
                 COUNT(Sheet1[Customer])
                 , mois_prec
            ) = 0
            , "New"
        )
vanessafvg's avatar
vanessafvg
Community Champion
3 years ago

is it only the previous month your are interested in or if they have never had a revenue date before? basically just taking their first date and assigning it to new?

united2win's avatar
united2win
Helper III
3 years ago

Only previous month please. I have a formula already to calculate if the customer has already recognized revenue in the past. Thank you.