Forum Discussion

Dane's avatar
Dane
Helper I
4 years ago
Solved

Token Comma Expected Error

I am trying to add a custom column in a table to calculate the difference between the date when an order is closed against when the order was opened.  Below is my formula.  I am getting a Token Comma...
Need Help
  • selimovd's avatar
    selimovd
    4 years ago

    Hey Dane ,

     

    right after the if you have 2 brackets Orders[[ClosedDate].

    Can you try to remove one of them?:

    New Column =
IF(
    Orders[ClosedDate] > 0,
    DATEDIFF(
        Orders[ClosedDate],
        Orders[Date],
        DAY
    ),
    DATEDIFF(
        TODAY(),
        Orders[Date],
        DAY
    )
)

     

    As you just want to get days you can also just subtract the the dates:

    New Column =
IF(
    Orders[ClosedDate] > 0,
        Orders[Date] - Orders[ClosedDate],
        Orders[Date] - TODAY()
)

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

     

Dane's avatar
Dane
Helper I
4 years ago

Thanks for the quick reply.  I subtracted the dates from each other as you specified in your example, there were no syntax errors, I deployed the change and am getting the error message below saying the name "IF" was not recognized, its asking me to make sure it was spelled correctly, do you know what may be causing this?

 

 

selimovd's avatar
selimovd
Most Valuable Professional
4 years ago

Hey Dane ,

 

seems like you put the Power Query formula (M language) in the Power BI calculated column (DAX language).

Just copy the formula I posted in the last answer  as calculated column. That should do it.

 

Best regards

Denis