Forum Discussion

CJC_DB's avatar
CJC_DB
Frequent Visitor
3 years ago
Solved

PowerBI - table auto filling

First of all I have to mentoine, that this project is my first PowerBi project.   I have uploaded some EXCEL tables into PowerBI. One table is containing various line which have the same part numbe...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    CJC_DB , You can have a new column

     

    coalesce([Status], "B")

     

    or replace with one value

     

    or find a value and replace

     

    coalesce([Status], maxx(filter(Table, [Part no] = earlier([Part no]) ) , [Status])

     

     

  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, CJC_DB 

     

    You can try the following methods.
    Column:

    Column = CALCULATE(MAX('Table'[Status]),FILTER('Table',[part no]=EARLIER('Table'[part no])))
    Column 1 = CALCULATE(MAX('Table'[Status.1]),FILTER('Table',[part no]=EARLIER('Table'[part no])))

    Are these 2 columns the output you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, CJC_DB 

 

You can try the following methods.
Column:

Column = CALCULATE(MAX('Table'[Status]),FILTER('Table',[part no]=EARLIER('Table'[part no])))
Column 1 = CALCULATE(MAX('Table'[Status.1]),FILTER('Table',[part no]=EARLIER('Table'[part no])))

Are these 2 columns the output you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.