Forum Discussion
Solved
create new Column
Hi Team Please help me i need new Column Gate entery Basis if gatey entery multipule i need single amount Freight amount Like my output. Gate entry Freight Amount CDA1031293 ...
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
IN DAX
https://1drv.ms/u/s!AiUZ0Ws7G26Rixu4oV5LW2VcErUY?e=4oFKH2
Hi shri0025 ,
Please try below steps:
1. add an index column in Power Query pane
2. create a new column with below dax formula
Column = VAR cur_entry = [Gate entry] VAR cur_index = [Index] VAR tmp = FILTER ( 'Table', [Gate entry] = cur_entry ) VAR _a = MINX ( tmp, [Index] ) RETURN IF ( cur_index = _a, [Freight Amount], 0 )Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
shri0025 Try to create a calculated column using this DAX:
Create Column =
VAR GateEntry = YourTableName[Gate Entry]
VAR FreightAmount = YourTableName[Freight Amount]
VAR GateEntryCount = CALCULATE(COUNTROWS(YourTableName), ALLEXCEPT(YourTableName, YourTableName[Gate Entry]))
RETURN
IF(GateEntryCount = 1, FreightAmount, 0)If you find this insightful, please provide a Kudo and accept this as a solution.
Hi Devesh
Thanks for reply it is not working
shri0025 Can you specify any error that you're getting?
