Forum Discussion
Create a new table from existing table (Using DAX Commands)
Hello my saviours, Hope you are all good. I need to create a new table based on calculation from Table 1 My table looks like this Table 1: IDNO Store_Number Slow AA1 S1 y AA1 S2 n...
Anonymous
It can actually be done in a far, far easier way if you have a column that specifies order in Table1 (or add an index as suggested by nandic). In my previous take, I somehow (must have been asleep) assumed you wanted a solution that would use the "Affected by" column in "Table1 (updated)". This only overcomplicates things unnecessarily
Table2 = GENERATE ( Table1, SELECTCOLUMNS ( CALCULATETABLE ( DISTINCT ( Table1[Store_Number] ), Table1[Index] < EARLIER ( Table1[Index] ), Table1[Slow] = "y", ALLEXCEPT ( Table1, Table1[IDNO] ) ), "Affected by", Table1[Store_Number] ) )Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Anonymous , from the perspective of Power Query, Table 1 (Updated) and Table 2 is identical but only by different transformations.
I'm having difficulty understanding what you want.🤔