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.
Hello all,
I have those two tables:
Table1
Table2:
I would like to create a new column in Table2 where i get the ProductId from Table1 depending on the dates.
Dates between 23-06-2022 and 04-07-2022 in Table1 should have ProductID = 05-07-2022_Ba,
dates between 05-07-2022 and 27-07-2022 in Table1 should have ProductID = 28-07-2022_Ba, and so on.
Do you have any suggestion?
Thank you.
Solved! Go to Solution.
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
Product ID CC =
SUMMARIZE (
FILTER (
Table1,
Table1[Load date]
= MINX (
FILTER ( Table1, Table1[Load date] > Table2[TimeStamp] ),
Table1[Load date]
)
),
Table1[ProductID]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
Product ID CC =
SUMMARIZE (
FILTER (
Table1,
Table1[Load date]
= MINX (
FILTER ( Table1, Table1[Load date] > Table2[TimeStamp] ),
Table1[Load date]
)
),
Table1[ProductID]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
119 | |
83 | |
47 | |
42 | |
33 |
User | Count |
---|---|
190 | |
79 | |
72 | |
52 | |
46 |