Forum Discussion
Filtering a particular column based on parameter
Following are my column headers: I have a parameter which dynamically changes everyday, i want my dashboard to use a different column based on the parameter value. That is, if my parameter has...
Rather than unpivot, I transposed the data to have the dates in rows, and filtered the row based on the parameter
Column1 is the transposed date column, MaxDate is my parameter.
I did another transpose again, to get it back as a column
Rather than unpivot, I transposed the data to have the dates in rows, and filtered the row based on the parameter
Column1 is the transposed date column, MaxDate is my parameter.
I did another transpose again, to get it back as a column