Forum Discussion
Return Dynamic Quarters Q1,Q2 Value
Hi All, I have 4 columns Q1,Q2,Q3,Q4. So based on current quarter it should return respective Q value. For example, Currently we are in Febraury, so it should return Q1 value, If we are in May ...
So, How do you calculated [Q1],[Q2],[Q3],[Q4] measures. are they Aggregated ?
Q1,Q2,Q3,Q4 are raw data, not measures/ calcualted columns.
But how can we pass those columns directly to a measure, we can do that by aggregation functions.
How did do you that ?