Forum Discussion

WilliamAzevedo's avatar
WilliamAzevedo
Advocate II
1 year ago
Solved

Status column based on another table

Hello, everyone.   I manage projects through a table and it's Statuses through a proper table with that goal. Example:   Statuses Status Project Date Canceled P3 12/01/2024 Complete...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    1 year ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

     

     

     

    Status CC =
VAR _currentproject = Projects[Project]
VAR _latestdate =
    MAXX ( RELATEDTABLE ( Statuses ), Statuses[Date] )
RETURN
    CALCULATE (
        MAX ( Statuses[Status] ),
        Statuses[Date] = _latestdate,
        Statuses[Project] = _currentproject
    )

     

WilliamAzevedo's avatar
WilliamAzevedo
Advocate II
1 year ago

The formatting was weird and I had to delete my first reply. I hope it goes right this time.

The first time I tried, I had this error:

 

A single value for column '…' in table '…' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

 

Then I searched in the forums what it meant and I found this topic: Solved: Re: A Single Value for Column Cannot Be Determine... - Microsoft Fabric Community

I followed the instructions Greg_Deckler posted here: Solved: Re: A Single Value for Column Cannot Be Determine... - Microsoft Fabric Community

 

My code ended up this way:

UltimoStatus = 
VAR proj_at = MAX(lst_projetos_unfa[Projeto e Processo])
VAR ult_data =
    MAXX(RELATEDTABLE(lst_evolucao_projetos_unfa), lst_evolucao_projetos_unfa[Data])
RETURN
    CALCULATE(
        MAX(lst_evolucao_projetos_unfa[Status]),
        lst_evolucao_projetos_unfa[Data] = ult_data,
        lst_evolucao_projetos_unfa[Projeto e Processo] = proj_at
    )

 

An it worked! I hope the post goes correctly this time and I can properly say thank you!