I have a powerbi table datasource that is bringing in 1900/01/01 value into the table.
I need to replace this value with null. I tried below function but it's not working
NewDate = if(Table[Date] = DATE(1900,01,01),BLANK(),Table[Date])
If I try to replace it with text value null, I see datatype error since the false condition returns date type.
Go to Solution.
You can click Query Editor->Transform->Replace Values
The result is like below;
View solution in original post
Check out the changes to the Power BI Community announced at Build.
Find out more about the May 2023 update.
Visit our Data Stories Gallery and give kudos to your favorite Data Stories.