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

v-janeyg-msft - the table has dates from 2021 to 2023. The snip that I took is from the top, which only shows the older, closed projects. There are dates in the table that span each week of the year. Hope that helps.