Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

On calculated field, using the date hierarchy causes an error.

Hi, everyone.    I created a date field that pulls the date from one field if populated, otherwise it pulls the date from another field. However, when I try and use the calculated date field in a v...
Need Help
  • sornavoor's avatar
    sornavoor
    10 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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's avatar
sornavoor
Icon for Resolver I rankResolver I
10 years ago

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