Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi all
I need to create a column (power bi desktop -> power query -> custom column) with the minimum date based on the content of another column. here what I have and what I wish
ITEM | Data_check | Event | NEW_COLUMN |
ITEM_01 | 31/03/2022 | Event_04 | 31/03/2022 |
ITEM_01 | 20/06/2022 | Event_04 | 31/03/2022 |
ITEM_01 | 20/09/2022 | Event_04 | 31/03/2022 |
ITEM_01 | 20/12/2022 | Event_04 | 31/03/2022 |
ITEM_01 | 30/03/2023 | Event_04 | 31/03/2022 |
ITEM_01 | 20/06/2023 | Event_04 | 31/03/2022 |
ITEM_01 | 20/09/2023 | Event_04 | 31/03/2022 |
ITEM_01 | 20/12/2023 | Event_04 | 31/03/2022 |
ITEM_01 | 20/03/2024 | Event_04 | 31/03/2022 |
ITEM_01 | 20/06/2024 | Event_04 | 31/03/2022 |
ITEM_01 | 20/09/2024 | Event_04 | 31/03/2022 |
ITEM_01 | 20/12/2024 | Event_04 | 31/03/2022 |
ITEM_01 | 20/03/2025 | Event_04 | 31/03/2022 |
ITEM_01 | 20/06/2025 | Event_04 | 31/03/2022 |
ITEM_01 | 22/09/2025 | Event_04 | 31/03/2022 |
ITEM_01 | 22/12/2025 | Event_02 | 31/03/2022 |
ITEM_02 | 23/08/2022 | Event_03 | 23/08/2022 |
ITEM_02 | 23/08/2022 | Event_03 | 23/08/2022 |
ITEM_02 | 23/08/2023 | Event_03 | 23/08/2022 |
ITEM_02 | 23/08/2024 | Event_03 | 23/08/2022 |
ITEM_02 | 25/08/2025 | Event_03 | 23/08/2022 |
ITEM_02 | 24/08/2026 | Event_03 | 23/08/2022 |
ITEM_02 | 30/08/2027 | Event_02 | 23/08/2022 |
ITEM_03 | 23/05/2022 | Event_03 | 23/05/2022 |
ITEM_03 | 22/05/2023 | Event_03 | 23/05/2022 |
ITEM_03 | 21/05/2024 | Event_03 | 23/05/2022 |
ITEM_03 | 21/05/2025 | Event_03 | 23/05/2022 |
ITEM_03 | 21/05/2026 | Event_03 | 23/05/2022 |
ITEM_03 | 28/05/2027 | Event_02 | 23/05/2022 |
tx for any help
Solved! Go to Solution.
measure = calculate(min(tbl[Data_check]),allexept(tbl,tbl[item]))
there's something wrong.
can you help me?
thank you
raffaele
@ironpink this is a DAX measure which is not to be used as POWER QUERY expression
so, how can I add a column here with the data above asked?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
62 | |
51 | |
47 |
User | Count |
---|---|
213 | |
81 | |
64 | |
60 | |
56 |