Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Create a new column using the measure

Hi Support team,   Is there a way to create a new column using the measures. for example i have a measure which is active/in active records.i want to convert this measure in to a column which can ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, Anonymous 

Thanks for NaveenGandhi and SachinNandanwar positive reply. In fact, your idea would work, writing Column = [Measure] directly. But if your Measure keeps changing, then your Column will need to be regenerated, and the Column's value won't change as the Measure changes

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Thanks for the response .

 

I tried the Cloumn =Measure name 

but when i put the both column and Mesure in one visual ,both the records not matching at row level,any idea how to fix this.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Anonymous 

    As I said above, if your data or Measure's calculation rules change after the Calculate Column is generated, the Calculate Column will not change automatically. If this is not the situation, you can provide some pbix files without sensitive data for testing. Feel free to help you about this problem.

    Best Regards,
    Yang
    Community Support Team