Forum Discussion

LéaGr's avatar
LéaGr
Helper I
6 years ago
Solved

Create a column from loop

Hi everybody,   I have an issue creating a column from what I feel could come from a "for each" loop. As no function of the sort exists in DAX I am stuck.   Here is a simplified version of my dat...
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi LéaGr ,

     

    You can create a Calculated column as follows using DAX:

     

    TestCol = CALCULATE(
                                        MAX(Table1[Status]),
                                        FILTER(
                                                   ALLSELECTED(Table1), Table1[ID] = EARLIER(Table1[ID])
                                                  )
                                        )
     
    Replace Table1 in above DAX expression with your's table-name.
     
    Thanks,
    Pragati
Pragati11's avatar
Pragati11
Super User
6 years ago

Hi LéaGr ,

 

Yes this solution will work with filters as well. You can test it.

If it doen't work let me know.

 

Thanks,

Pragati

LéaGr's avatar
LéaGr
Helper I
6 years ago

Hi Pragati11 ,

 

I tested recently the solution and I was indeed able to create the calculated column but it does not adapt to filter. Indeed I have a date filter and the maximum seems to be calculated among the whole table and not the filtered table by date.

Maybe an equivalent measure could do the job?

I can send you the pbix if it helps.

Thanks a lot!

 

Best,

 

Léa