Solved: Creating Quartile Labels as a Calculated Column

Anonymous · ‎03-31-2019

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 · ‎04-16-2019

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

v-frfei-msft · ‎04-01-2019

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.

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Anonymous · ‎04-03-2019

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

Thank you!

v-frfei-msft · ‎04-16-2019

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.