Forum Discussion

dedelman_clng's avatar
dedelman_clng
Community Champion
9 years ago
Solved

August update broke Conditional Columns for date fields?

I initially created a dashboard with the July version of PowerBI desktop and added a conditional column in a query:                             Now I have the August update, and ...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi dedelman_clng,

     

    Based on my test on Power BI Desktop 2.38.4491.282 version, when we add a new conditional column in the query, the column will return correct data, though the operator is missing when we open the conditional column settings again. As you can see the formula is also perform 'Is Before' function.

     

     

     

    In your scenario, please try to recreate this additional column in query editor, check which formula is used for this column.

     

    Meanwhile, I will report the issue about missing operator in additional settings.

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu

  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    dedelman_clng

     

    This issue will be addressed in September release of PBI Desktop. Please wait for the coming update and have another try later.

     

    Best Regards,

    Herbert

dedelman_clng's avatar
dedelman_clng
Community Champion
9 years ago

Hi Qiuyun_Yu  -

 

You are correct - the column is calculating correctly.  I was incorrect about that.  But the blank operator is still a cause for concern.

 

Thanks.

trebgatte's avatar
trebgatte
Most Valuable Professional
9 years ago

You can add your own screenshots to the top of the email that the Send a Frown generates. I've attached video before as well.

 

 

Treb Gatte | Business Solutions MVP | Power BI Recordings | @tgatte | Blog