Hi
I am new to power bi. I have two tables like table 1 "item master" and table 2 "item ledger" i want to create a new column for "last sale date" Please help me to create a lookup column in item table. Picture attached
Solved! Go to Solution.
Hi @jaafer,
You can simply use summarize function to create a table to store summarized 'item no' and max 'post date'.
Table = SUMMARIZE ( FILTER ( 'Sample', [entry type] = "sale" ), [item no], "MaxDate", MAX ( 'Sample'[posting date] ) )
Regards,
Xiaoxin Sheng
HI @jaafer,
Nope, it not in query editor, it is dax formula.
You can navigate to modify tab and choose new table, then input these to formula panel.
Regards,
Xiaoxin Sheng
i want to retrieve the latest date from "posting date" field and from "entry type" field equals to "sale". Thanks.
Hi @jaafer,
You can simply use summarize function to create a table to store summarized 'item no' and max 'post date'.
Table = SUMMARIZE ( FILTER ( 'Sample', [entry type] = "sale" ), [item no], "MaxDate", MAX ( 'Sample'[posting date] ) )
Regards,
Xiaoxin Sheng
Thank you very much brother, it worked well...
@v-shex-msft ok I got it.. how to create a table. Actually i need to add a new column in table "item master" with a field " last sale date" Can u please help
Thank you very much for reply. Can you please tell me where i will apply this code. Is it in query editor. Please I am very new to Power Bi
HI @jaafer,
Nope, it not in query editor, it is dax formula.
You can navigate to modify tab and choose new table, then input these to formula panel.
Regards,
Xiaoxin Sheng
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
User | Count |
---|---|
179 | |
67 | |
65 | |
57 | |
55 |
User | Count |
---|---|
184 | |
103 | |
89 | |
75 | |
72 |