Forum Discussion

tangutoori's avatar
tangutoori
Icon for Helper III rankHelper III
3 years ago
Solved

slicing table for related historical data

Dear All,   here is the secenario.   SlicerTable = DISTINCT (     UNION (         VALUES ( 'Test Data'[Replace 1]),         VALUES ('Test Data'[Replace 2] ),         VALUES ('Test Data'[R...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi tangutoori ,

    Please hvae a try.

    Create another table with the SlicerTable[Replace 1] column .

    Create a measure.

    Measure = var _1=SELECTEDVALUE('Table 2'[id])
return
if(SEARCH(_1,MAX('Table'[id]),1,0)=1,MAX('Table'[id]),BLANK())

    You can try to use search:

    SEARCH function (DAX) - DAX | Microsoft Learn

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi tangutoori ,

Please hvae a try.

Create another table with the SlicerTable[Replace 1] column .

Create a measure.

Measure = var _1=SELECTEDVALUE('Table 2'[id])
return
if(SEARCH(_1,MAX('Table'[id]),1,0)=1,MAX('Table'[id]),BLANK())

You can try to use search:

SEARCH function (DAX) - DAX | Microsoft Learn

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.