Forum Discussion
Nathan___Mox
4 years agoRegular Visitor
filter out value in calculation for dates
Hi all,
I am wanting to make a calculation to add 11 days too a date column, but Since some cells dont have a date when i make the calculation it makes all the blank rows = 10/01/1900. I was hoping someone could help filter out the blank cells when doing the above calculation. I'm new to this so any help would be much appreciated.
Thanks
Nathan
IF(NOT(ISBLANK(yourTable[yourDateColumn])), yourCode)
3 Replies
- lukiz84Memorable Member
IF(NOT(ISBLANK(yourTable[yourDateColumn])), yourCode)
- lukiz84Memorable Member
In a calculated column or in a measure?
- Nathan___MoxRegular Visitor
calculated column