Forum Discussion
LéaGr
Helper I
Helper ICreate 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...
Pragati11
Super User
Super UserHi 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éaGrThanks 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