Forum Discussion

LéaGr's avatar
LéaGr
Icon for Helper I rankHelper 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
LéaGr's avatar
LéaGr
Icon for Helper I rankHelper I
6 years ago

Thanks for your swift answer Pragati11 !!

That works, I will mark it as the solution. I have a complementary question thow, will the column adapt to the filters? I have another column with dates and a date filter in my page, will the maximum be determined between the selected date or once and for all among all data?

It it does not adapt to the filter, do you know how I could acheive that?

 

Many thanks,

Best,

 

Léa

Pragati11's avatar
Pragati11
Icon for Super User rankSuper 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
    Icon for Helper I rankHelper I
    6 years ago

    Gear thank you very much! I really appreciate how helpful and fast you are.

     

    Have a great day!

     

    Léa

  • LéaGr's avatar
    LéaGr
    Icon for Helper I rankHelper 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