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.
Solved! Go to Solution.
Hi BrianSK,
You can click Query Editor->Transform->Replace Values
The result is like below;
Regards,
Jimmy Tao
Hi BrianSK,
You can click Query Editor->Transform->Replace Values
The result is like below;
Regards,
Jimmy Tao
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
125 | |
78 | |
69 | |
54 | |
53 |
User | Count |
---|---|
191 | |
104 | |
83 | |
79 | |
78 |