Forum Discussion

Joseph_Hchaime's avatar
Joseph_Hchaime
Icon for Helper III rankHelper III
4 years ago
Solved

Having trouble with DAX formula

Hi,   I need to translate a formula into a dax measure.    The formula is: # new clients opened and billed this period/ total # of clients billed in the same period (not only new)   My data has...
Need Help
Show and Tell
Tutorial Requests
  • Ale's avatar
    Ale
    4 years ago

    It could be because you are comparing a full Date with a Year.

     

    Try adding YEAR() to all the dates.

    Year(Client_Creation_Date) = Year (Today())

    Year(Bill_Issue_Date) = Year (Today())

Ale's avatar
Ale
Icon for Resolver II rankResolver II
4 years ago

You must use Today() and not only Today.

Year(Today())
  • Joseph_Hchaime's avatar
    Joseph_Hchaime
    Icon for Helper III rankHelper III
    4 years ago

    I noticed that and I corrected it after posting my reply. The thing is I'm getting blank as a result. Whereby I'm positive we've billed new clients this year 

    • Ale's avatar
      Ale
      Icon for Resolver II rankResolver II
      4 years ago

      It could be because you are comparing a full Date with a Year.

       

      Try adding YEAR() to all the dates.

      Year(Client_Creation_Date) = Year (Today())

      Year(Bill_Issue_Date) = Year (Today())