Forum Discussion

renlaforest's avatar
renlaforest
Helper I
4 years ago
Solved

Target to date

Hello - I'm new to Power BI and DAX. I've strugged with figuring out the following. I have a start date for the project and a close date, and I created a column to calculate the total number of days...
target
to date
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, renlaforest 

     

    This error shows that you are using the custom column feature in powerquery.

    But the code is DAX, not M code. You need to create it in desktop.

     

    Best Regards,
    Community Support Team _ Janey
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

renlaforest's avatar
renlaforest
Helper I
4 years ago

Thank you so much for your help. For some reason, and I've tried Googling (unsuccesfuly) what could be causing it, but I get an error message: Expression.Error: The name 'IF' wasn't recognized. Make sure it's spelled correctly.

I have:

IF (
TODAY () > [Start Date],
IF (
TODAY () <= [Close Date],
([EN Targeted Completes]
/ ( DATEDIFF ( [Start Date], [Close Date], DAY ) + 1 ))
* ( DATEDIFF ( [Start Date], TODAY (), DAY ) + 1 ),
[EN Targeted Completes]
),
0
)

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

Hi, renlaforest 

 

This error shows that you are using the custom column feature in powerquery.

But the code is DAX, not M code. You need to create it in desktop.

 

Best Regards,
Community Support Team _ Janey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.