Forum Discussion

rohithkothaneth's avatar
rohithkothaneth
Icon for Resolver I rankResolver I
3 years ago

Matrix visual picking the filtered column value as column name for the column

Hello, I'm looking for a solution suggestion here.  In the Matric visual, could I give a custom static column_name rather than PBI using the filtered value itself from a column as a column name   ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Count of Records = Calculate(Countrows('Main Table'),[Year_Quarter]="2021-Q1")

rohithkothaneth's avatar
rohithkothaneth
Icon for Resolver I rankResolver I
3 years ago

Great thanks.

If i use [Year_Quarter] as a filter and needs to be picked dynamically as max(Year_Quarter), i will need to use a FILTER function here?

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?