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

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"
    )
  • united2win's avatar
    united2win
    Helper III
    3 years ago

    Thanks Thomas, but still didn't work.

     

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