Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

COPY VALUE FROM ANOTHER COLUMN

Dear   Find below Table Values & Output view   Current Table - If Ref & ID both are same copy claim amount to ID aslo   Table 1               ID Name Service Class Food Ref ...
Need Help
  • rocky09's avatar
    rocky09
    7 years ago

    Your Query is not clear. Can you please provide some more inforamtion along with a single example.

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

To ceate a measure as below.

 

Measure = 
IF (
    ISBLANK ( MAX ( Table1[Claims] ) ),
    CALCULATE (
        FIRSTNONBLANK ( Table1[Claims], SUM ( Table1[Claims] ) ),
        FILTER ( ALL ( Table1 ), Table1[Ref] = MAX ( Table1[ID] ) )
    ),
    MAX ( Table1[Claims] )
)

 

Regards,

Frank

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    How to Copy the Date Value Same Like the above Table