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 ...
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,