Forum Discussion
Table - Using String Data Applying Different Filters (Ignoring Table Filters)
Hi powerbi5353 - You can create a calculated column or a measure like this
eg:
PriorYearComment =
CALCULATE(
MAX(SalesData[Comment]), -- or CONCATENATEX(...) if multiple comments
FILTER(
ALL(SalesData), -- removes existing filters on the table
SalesData[Year] = FORMAT(VALUE(SELECTEDVALUE(SalesData[Year])) - 1, "0000")
&& SalesData[Customer] = SELECTEDVALUE(SalesData[Customer])
)
)You filter the visual or report using Year = 2024, but you want to retrieve Comment from 2023. hope this works. please check
Hi powerbi5353
Thank you for reaching out microsoft fabric community forum.
I wanted to check if you had the opportunity to review the information provided by rajendraongole1 . Please feel free to contact us if you have any further questions. If his response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.