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

sornavoor's avatar
sornavoor
Icon for Resolver I rankResolver I
10 years ago

Never mind, Just tried it -  not working with FORMAT either

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Thanks, sornavoor! Oddly, I started by changing the format, but adding the calculated date to a new visual did nothing. And then when I added in the format function around my if statement, I got an error. It was not until I deleted the format function and forced a recalculation that the visual started showing the proper date hierarchy! Strange, but thanks so much for your help!

       

      Scott

      • ericleigh007's avatar
        ericleigh007
        Icon for Advocate II rankAdvocate II
        9 years ago

        Yes, this is definitely a bug.

         

        If this happens, you have to toggle the formst back and forth.

         

        I toggled back to date, and then back to date/time for my field, and that caused the hierarchy to show up.

         

        Would be great if the team could fix that one.  Took me a whliei to find the answer and then mess around a bit before i was able to work around it.