Forum Discussion

sanct's avatar
sanct
Frequent Visitor
7 years ago
Solved

Replace Values in Row with Values from another specific cell

Hi All,   I'm trying to replace the values in one cell with the values from another specific cell. I'll start with the data model I'm using:   In a nushell, I have the results of an extensive sur...
Need Help
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    Hi sanct ,

    Please refer to the following DAX query:

    CalculatedCategory =
CALCULATE (
    MIN ( Table1[Value] ),
    FILTER (
        ALL ( Table1 ),
        Table1[ResponseID] = EARLIER ( Table1[ResponseID] )
            && (
                Table1[Category] = EARLIER ( Table1[Category] )
                    || RIGHT ( Table1[Category], 1 ) = RIGHT ( EARLIER ( Table1[Category] ), 1 )
            )
            && Table1[Value] <> BLANK ()
            && Table1[Value] <> "Yes"
    )
)

    The result will like below:

    Best Regards,

    Teige

TeigeGao's avatar
TeigeGao
Solution Sage
7 years ago

Hi sanct ,

Please refer to the following DAX query:

CalculatedCategory =
CALCULATE (
    MIN ( Table1[Value] ),
    FILTER (
        ALL ( Table1 ),
        Table1[ResponseID] = EARLIER ( Table1[ResponseID] )
            && (
                Table1[Category] = EARLIER ( Table1[Category] )
                    || RIGHT ( Table1[Category], 1 ) = RIGHT ( EARLIER ( Table1[Category] ), 1 )
            )
            && Table1[Value] <> BLANK ()
            && Table1[Value] <> "Yes"
    )
)

The result will like below:

Best Regards,

Teige

sanct's avatar
sanct
Frequent Visitor
7 years ago

Thank you so much TeigeGao  !

 

It took a little tweaking on my part to make it work with my actual dataset (there were additional categories to consider) but I was able to make it work.

 

I'm going to keep this formula handy :)