Forum Discussion
Creating Quartile Labels as a Calculated Column
Hello, I have a table with data that includes a column Total Visits. I want to create an additional calculated column referencing the Quartile that that row's visit number falls in. The end goal ...
Hi Anonymous ,
What is your excepted output? I cannot catch the quartile labels here? Did you want to get the quater of a year like the formula as below.
Column = FORMAT('Sheet1'[Metric Date],"Q")
Sample data here: https://drive.google.com/file/d/1NJ3jeTWdDOQvD6aldC1Bnk8Hjl9-Jf5l/view?usp=sharing
Thank you!
Hi Anonymous ,
What is your excepted output? I cannot catch the quartile labels here? Did you want to get the quater of a year like the formula as below.
Column = FORMAT('Sheet1'[Metric Date],"Q")