Forum Discussion
Mohsin2022
Helper I
Helper ISUM RESULT SHOULD BE SHOWN AGAINST ONE ROW
I WANT TO SUM DATA BASED ON PROD ID BUT SUM VALUE SHOULD BE SHOWN ON SINGLE ROW NOW ALL THE LINE HAVE SAME VALUE
Mohsin2022
You need first to add an index column using power query.Then creat a new calculated column using dax
Result = VAR CurrentIDTable = CALCULATETABLE ( Data, ALLEXCEPT ( Data, Data[ProdID] ) ) VAR CurrentIndex = Data[Index] VAR FirstIndex = MINX ( CurrentIDTable, Data[Index] ) RETURN IF ( CurrentIndex = FirstIndex, Data[Current] )Mohsin2022
Please useBOMID New = CALCULATE ( MAX ( Data[BOMID] ), ALLEXCEPT ( Data, Data[ProdID] ) )
tamerj1
Community Champion
Community ChampionMohsin2022
You need first to add an index column using power query.
Then creat a new calculated column using dax
Result =
VAR CurrentIDTable = CALCULATETABLE ( Data, ALLEXCEPT ( Data, Data[ProdID] ) )
VAR CurrentIndex = Data[Index]
VAR FirstIndex = MINX ( CurrentIDTable, Data[Index] )
RETURN
IF ( CurrentIndex = FirstIndex, Data[Current] )
Mohsin2022Helper I
Helper Itamerj1 THANKS DEAR ITS WORKING
- tamerj1