Forum Discussion

harshagraj's avatar
harshagraj
Post Partisan
6 years ago
Solved

Calculated column to change Names

Hi all, Please find the below table. I need a calculated column and below is the requirement. If the Gate is G3 and Recommendation is Approve The Gate remais same I,e G3. If after G3 when the proje...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi harshagraj ,

    You can create one calculated column as below:

    Calculated = if('Table'[Recommendation]="Approve",'Table'[Gate],CALCULATE(max('Table'[Gate]),FILTER('Table','Table'[Gate]<EARLIER('Table'[Gate]))))

    Best Regards

    Rena

harshagraj's avatar
harshagraj
Post Partisan
6 years ago

Hi Anonymous yes u were correct with the column you mentioned. That is what i need for. Actually its based on the Project numbers.Intially it starts from G1-G6. But our scope is grom G3 only. As we are not bothered about G1- G2 gates. The thing is due to data restictions i cant upload the full data. Please please let me know how i can help you further.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi harshagraj ,

You can create one calculated column as below:

Calculated = if('Table'[Recommendation]="Approve",'Table'[Gate],CALCULATE(max('Table'[Gate]),FILTER('Table','Table'[Gate]<EARLIER('Table'[Gate]))))

Best Regards

Rena

  • harshagraj's avatar
    harshagraj
    Post Partisan
    6 years ago

    Hi Anonymous thanks a lot for the solution you provided.
    It was working absolutely fine. Now i have a small problem. Please see the screenshot below The calculation you provided me is Calculated Gate Column.  It is showing 3 rows instead of one. Please help me. 2020 Project Gate has G5 and Calculated Gate should only have G5.