Forum Discussion
VoltesDev
4 years agoHelper V
Table visual : text mask-ing
Hi everyone, Probably the title is weird, but what I meant is, if lets say in my table I have a field Text which contain date, something like this : Is there a trick that when we display ...
- 4 years ago
VoltesDev , You need to have new column in power query or dax , just at time of display you can not suppress
=
if [Date] = #date(1900,01,01) then null else [Date]
or in dax
if([Date] = Date(1900,01,01) , blank(), [Date])
amitchandak
4 years agoSuper User
VoltesDev , You need to have new column in power query or dax , just at time of display you can not suppress
=
if [Date] = #date(1900,01,01) then null else [Date]
or in dax
if([Date] = Date(1900,01,01) , blank(), [Date])