Forum Discussion
Column Name
Hi Comunity Team, Can a measure tretreive a column name? What I am trying to do is filtering data based on a column name. Thanks and regards.
Hi Ricardo!!!
That is almost what I am looking for, is there a way I can replace the Dynamic table for a Slicer with date values?
For instance, if Country is CAN, then show a slicer from column "Canadian Holidays", if Country is JPN, then show a slicer from column "Japan Holidays" and if Country is USA then show a slicer from column "USA Holidays"
Thansk in advance for your suport Ricardo 😃
Hi jx615k ,
Try creating a calculated column for the second slicer - for the column canadian holidays. Your first slicer would be country.
CALCULATE(VALUES('COLUMN-CANADIAN HOLIDAYS', ALLSELECTED(COUNTRY))
Based on the selection from your first slicer, this calculated column will populate the holiday values for Canada.