Forum Discussion

MartinC's avatar
MartinC
Icon for Helper I rankHelper I
2 years ago

Getting a date value from a text column

Hi All,   I am using data from Primavera P6, copied into Excel, and then used in Power BI.  My portfolio of projects is approximately 300 different projects.  Each one has 10 of the same milestones...
Need Help
ajohnso2's avatar
ajohnso2
Icon for Solution Supplier rankSolution Supplier
2 years ago

Are your dates stored as dates in power query?

If not add or replace your current date column as Date.FromText(<date column>, "dd/mm/yyyy")

 

Your Dax measure perhaps wont work if you are mixing string with dates.

 

Try

if('Activities'[Activity Name] = "Project Brief Accepted", 'Activities'[Finish Date], BLANK())

  • MartinC's avatar
    MartinC
    Icon for Helper I rankHelper I
    2 years ago

    Thanks for the suggestion, I did try that and just get #ERROR