Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

USERELATIONSHIP do not work anymore

Hello everyone, I am facing some issue with Power BI. I recently updated my Power Query Editor from " 'Power Query M' language and Applied Steps" to a full data transformation via a Python script ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Yes. That is the problem. Create a date column and join that with date table

     

    TASK Date = [TASK Created].Date

     

     

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , I doubt Task created has timestamp. Please change the data type to datetime and choose format to have time to check

 

Create one without time

Task Date =[Task created.Date 

 

Join this column and use

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello amitchandak ,

 

Thanks for your response,

 

I don't think this is the problem. As you can see on the screenshot below,  the data type for "TASK Created" is datetime.

 

 

I have no clue where the problem come from.

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , Yes. That is the problem. Create a date column and join that with date table

     

    TASK Date = [TASK Created].Date

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello amitchandak,

       

      You got it right ! I duplicated the original column ( [TASK Created] ) then changed the data type to "date" in the new column. 

       

      Creating a new column with this formula "= Datetime.Date([TASK Created])" work as well.

       

      Thanks you !