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.
Data looks like below, based on NOs. need output as "latest", "No" with reference Part. Tried below but failed.
REV = MAXX(FILTER(Part_Hist,Part_Hist[REV_NUM]>EARLIER(Part_Hist[REV_NUM])),IF(Part_Hist[Part Name]=EARLIER(Part_Hist[Part Name]),"Yes","No"))
REV = MAXX(FILTER(Table1,Table1[Nos]>EARLIER(Table1[Nos])),IF(Table1[Part]=EARLIER(Table1[Part]),"OLD","Latest"))
Solved! Go to Solution.
@KL718 Please try this as a New Column
Remarks = VAR _Max = CALCULATE(MAX(Test260FlagLatest[Nos]),ALLEXCEPT(Test260FlagLatest,Test260FlagLatest[Part])) RETURN IF(Test260FlagLatest[Nos]=_Max,"Latest","No")
Proud to be a PBI Community Champion
@KL718 Please try this as a New Column
Remarks = VAR _Max = CALCULATE(MAX(Test260FlagLatest[Nos]),ALLEXCEPT(Test260FlagLatest,Test260FlagLatest[Part])) RETURN IF(Test260FlagLatest[Nos]=_Max,"Latest","No")
Proud to be a PBI Community Champion
Thanks & appreciate.
I was also able to find the solution. Sharing another way which can be used to achieve the output.
I wrote DAX>>
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |