Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
86 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |