Forum Discussion
Solved
Table - Using String Data Applying Different Filters (Ignoring Table Filters)
New to BI - I have a table of data that is filtered by a specific year. I also want to bring in data from a prior year for comparative purposes. The way my data is structured I need to apply 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
Ashish_Mathur
Super User
Super UserHi,
Share some data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.