Forum Discussion

KWelsh8144's avatar
KWelsh8144
Icon for Helper II rankHelper II
7 years ago
Solved

Replacing a value in direct query mode

Hi, is it possible to add a column and add dax that would include something like.. if text.contains([date], "1800" then "" else ([date])? The problem is there is a default date in the view I'm using ...
Data Modeling
  • Anonymous's avatar
    Anonymous
    7 years ago

    KWelsh8144 ,

    Please perform the steps below.

    1. Make sure you have changed the type of DueDate field to Text in Power BI Query Editor.


    2. Load data to Data view of Power BI Desktop, then create the following column.

    Updated Due Date = if(find("1899",vProjects[DueDate],1,0)>0, BLANK(),vProjects[DueDate])


    3. Change the data type of the new column  to Date.


    Regards,
    Lyida

Anonymous's avatar
Anonymous
Not applicable
7 years ago

KWelsh8144 ,

Click on your date field, then change data type and format under modeling tab.


Regards,
Lydia