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.
Hi Team,
Any one can please help me to acheive below work item ?
I want DAX measure to create a new column Nssr Amount.
Regards,
Maruthi.P
Solved! Go to Solution.
Hi @immaruthi ,
You could refer to the following DAX:
Column =
LOOKUPVALUE('Table'[Amount],'Table'[ID],('Table'[Nssr ID]))
Here is my result.
Try
NSSR Amount = minx(filter(table,table[ID]=earlier(table[NSSR ID])),table[Amount])
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
Thanks for your reply. I am getting an error like -> 'Earlier/Earliest' refers to an earlier row context which doesn't exist.'
Hi @immaruthi ,
You could refer to the following DAX:
Column =
LOOKUPVALUE('Table'[Amount],'Table'[ID],('Table'[Nssr ID]))
Here is my result.
It's working fine. Thanks for your support.
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 |
---|---|
107 | |
93 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |