Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I am strugling with the following :
I have a table 1 with following info :
Quantity | Order | FRom Date | To Date |
12 | 124 | 01/01/22 | 02/04/22 |
32 | 124 | 02/04/22 | 4/5/22 |
45 | 124 | 4/5/22 | 12/2/22 |
and a second table with a column order and a column date
How do I add a column in the second table with the value "Quantity" based on the column date ?
Order | Date | Quantity |
124 | 3/3/22 | 32 |
124 | 7/1/22 | 45 |
Solved! Go to Solution.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi,
Please check the below picture and the attached pbix file.
Quantity CC =
MAXX (
FILTER (
Table1,
Table1[Order] = EARLIER ( Table2[Order] )
&& Table1[From Date] <= EARLIER ( Table2[Date] )
&& Table1[To Date] > EARLIER ( Table2[Date] )
),
Table1[Quantity]
)
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,
Please check the below picture and the attached pbix file.
Quantity CC =
MAXX (
FILTER (
Table1,
Table1[Order] = EARLIER ( Table2[Order] )
&& Table1[From Date] <= EARLIER ( Table2[Date] )
&& Table1[To Date] > EARLIER ( Table2[Date] )
),
Table1[Quantity]
)
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.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
46 | |
31 | |
30 | |
18 | |
18 |