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"
        )
Thomas_Daubert's avatar
Thomas_Daubert
Helper I
3 years ago

Sorry to ear that 😞 it was working on my Pbix file.

 

PS : Do you know how to add pbix files ? i can't find any option to do that.

united2win's avatar
united2win
Helper III
3 years ago

No worries, I have found the solution.