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:
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
Go to Solution.
Status While Ordering =MAXX (TOPN (1,FILTER (ALL ( StatusChanges ),StatusChanges[Customer Code] = Orders[Customer Code]&& StatusChanges[Date] <= Orders[Date]),StatusChanges[Date]),StatusChanges[New Status])
View solution in original post
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.