Forum Discussion
krishb1414
Helper III
Helper IIIReturn 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 ...
johnyip
Solution Sage
Solution Sage
The entity created is calculated column instead of mesaure.
The calculated column returns the values of some existing column of the raw data, depending on current quarter. No aggregration is present. The reason you see aggregration in the pictureis PowerBI by default use SUM aggregration in table. Nonetheless, you can see the sum of the data itself is equivalent to Q2,