Forum Discussion
On calculated field, using the date hierarchy causes an error.
It is funny - some observations ... was able to show the the hierarchy for calucated date after doig the following 2 actions.
a) Set the calculated date field to Date/Time
b) saved the pbix file.
then used the calcualted field in a visual....
I'm on Version: 2.34.4372.322 64-bit (April, 2016)
Hierarchy showing up for Date3Logic for the Calculated Date Field
Resolver IWondering if you tried forceing the calucated column's to "General Date" using the FORMAT dax expression?
- sornavoor
Never mind, Just tried it - not working with FORMAT either
Thanks for trying, sornavoor! It almost feels like it is getting caught in some type of circular reference, though not sure why, nor if that makes sense. But when the formatting matches and types match, I can't guess what would make it fail!
- sornavoor
It is funny - some observations ... was able to show the the hierarchy for calucated date after doig the following 2 actions.
a) Set the calculated date field to Date/Time
b) saved the pbix file.
then used the calcualted field in a visual....
I'm on Version: 2.34.4372.322 64-bit (April, 2016)
Hierarchy showing up for Date3Logic for the Calculated Date Field