Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
EMassicot
Frequent Visitor

DAX FUNCTION FOR TIERS?

With the data that I have, is there a way to create a column that tiers the Gross Chargbacks in tiers of 20%? I want the highest dollar value to be placed in the first 20% and so on. These tiers should be represented by a score of 1,2,3,4 and 5, with the first 20% being a 1.

 

I also have a date table in which I am joing to, that has the fiscal years. I want each fiscal year to be tiered. In other words I do not want the entire table to be tiered at once, rather I want to have a 20% tiered projection, one fiscal year at a time. Is there a way to do this?

 

 

 

Agent_IDGross ChargebacksDate of Chargeback
111$9977/1/2022
112$7557/1/2022
113$4818/1/2022
114$4328/1/2022
115$5608/1/2022

 

DateFiscal Year
7/1/2022FY2022
8/1/2022FY 2023
9/1/2022FY 2023
10/1/2022FY 2023
1 ACCEPTED SOLUTION
1 REPLY 1

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.