Creating Quartile Labels as a Calculated Column

[Anonymous]

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 is to use the quartile as the legend on a bar chart.

Thank you,

Ashley

[v-frfei-msft]

Hi @Anonymous ,

Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

[Anonymous]

Sample data here: https://drive.google.com/file/d/1NJ3jeTWdDOQvD6aldC1Bnk8Hjl9-Jf5l/view?usp=sharing

Thank you!

[v-frfei-msft · Accepted solution]

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")