Forum Discussion

Saxon10's avatar
Saxon10
Post Prodigy
4 years ago
Solved

DAX formula settings issue

Hi, 

 

The power BI formula bar setting has been changed. Usually when I try to create any DAX formula (by using new calculate column option) the formula bar automatically explains what need to do but now it's look like completely changed. it's vary painful to read the  table or field name during DAX formula creation.

 

Example... 

 

If I am trying to create a Lookupvalue function it will automatically explain.... Lookupvalue (Result _column, search _column, search _value 1,..…,,,alternative _results)

 

but now its not showing the explanation when try to create a DAX formula by using new calculate column option.

 

It's looks like the settings changed somewhere else but I don't know how to fix it. 

 

Could you please guide me where went wrong and how can I fix the problem. 

 

Herewith attached the snapshot for understanding my problem. 

 

Before.... (Previous settings of DAX formula) 

 

After (Current settings of DAX formula) 

 

 

DAX formula setting
setting issues.
  • Anonymous's avatar
    Anonymous
    4 years ago

    Saxon10 
    The oct version changed the DAX  guidance to the same style with Power Query, which is not announced in the feature summary. Power BI October 2021 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI

     

    My suggestion is to go back to the Sept version for now, and wait for the announcement or updates about this feature. Or if you want to use the newest version, you can try write your dax this online editor first.

    DAX.do by SQLBI

     

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

8 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    same here. I don't remember this change being mentioned in the release notes either.  

    • Saxon10's avatar
      Saxon10
      Post Prodigy
      4 years ago

      lbendlin, Thanks for your reply and sharing your experience.

       

      It's really annoying during DAX formula creation. 

       

      If I reinstall the power bi again maybe the problem automatically resolved?

      Any idea or suggestion please.

       

      • lbendlin's avatar
        lbendlin
        Super User
        4 years ago

        You would have to reinstall the September 2021 version.  That would be unfortunate as the October version has a couple neat features.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Saxon10 
    The oct version changed the DAX  guidance to the same style with Power Query, which is not announced in the feature summary. Power BI October 2021 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI

     

    My suggestion is to go back to the Sept version for now, and wait for the announcement or updates about this feature. Or if you want to use the newest version, you can try write your dax this online editor first.

    DAX.do by SQLBI

     

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

    • Saxon10's avatar
      Saxon10
      Post Prodigy
      4 years ago

      Hi Anonymous,

       

      Thanks for your reply and updating the information. 

       

      I will go through the link based on your advice and I hope the DAX guidance back to old method in next version. 

       

      • RA-Shiva7's avatar
        RA-Shiva7
        New Member
        4 years ago

        how to get install the september version 
        please let me know?
        im facing a lot of disturbance]