Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm having an issue with a default date of 1/1/1900. The field is LastDayWorked. When I pull data from the database, a blank field shows as 1/01/1900. On my report, I want it to be blank.
I have tried a new column of
NewLastDay=IF([LastDateWorked]=1/1/1900,BLANK(),[LastDateWorked]) but it still puts the default date in. I can't change the column type to text. Is there anything that can be done?
Solved! Go to Solution.
Hi @kattlees,
Please try this formula in a column ( I called my table data sample) :
Column = If('Sample'[DatelastWorked]=DATE(1900,01,01),BLANK(),'Sample'[DatelastWorked])
You can see the image below:
Ninter
Hi @kattlees,
Can you please send sample ( easy to copy and paste for example) data with your case and we wull try to figure out?
Thank you.
Ninter
Ninter, appreciate you trying to help.
I have a DateLastWorked column that is a Date format. If there is no value entered, it defaults to 1/1/1900
So might have
Name DatelastWorked
kathy 1/1/1900
Sue 9/15/2017
Jon 8/30/2017
Ninter 1/1/1900
I would want it to display as
Name DatelastWorked
kathy
Sue 9/15/2017
Jon 8/30/2017
Ninter
Hi @kattlees,
Please try this formula in a column ( I called my table data sample) :
Column = If('Sample'[DatelastWorked]=DATE(1900,01,01),BLANK(),'Sample'[DatelastWorked])
You can see the image below:
Ninter
Thank you so much. I just didn't have the DATE thing in there.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |