Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I have to data tables:
1. Status changes of customers:
2. Orders:
I wish to add a column to Orders table which presents the customer status as of each customer at its order date, as below:
Thanks in advance
Solved! Go to Solution.
Hi @akfir
please try
Status While Ordering =
MAXX (
TOPN (
1,
FILTER (
ALL ( StatusChanges ),
StatusChanges[Customer Code] = Orders[Customer Code]
&& StatusChanges[Date] <= Orders[Date]
),
StatusChanges[Date]
),
StatusChanges[New Status]
)
Hi @akfir
please try
Status While Ordering =
MAXX (
TOPN (
1,
FILTER (
ALL ( StatusChanges ),
StatusChanges[Customer Code] = Orders[Customer Code]
&& StatusChanges[Date] <= Orders[Date]
),
StatusChanges[Date]
),
StatusChanges[New Status]
)
Check out the November 2023 Power BI update to learn about new features.