Forum Discussion
Dividing data into equal quarters
Hi, I'm very new to PBI so any help would be much appreciated. I'm trying to break my data which shows hourly rate of each employee into 4 equal quarters, based on the hourly rate. The added complic...
Hi,
You can divide Hourly Rate data based on Number of Quarter.
I tried to divide in four quarter based on given conditions:
Quarter 1: Hourly Rate>=0 and Hourly Rate<=5
Quarter 2:Hourly Rate>5 and Hourly Rate<=10
Quarter 3:Hourly Rate>10 and Hourly Rate<=15
Quarter 4:Hourly Rate>15 and Hourly Rate<=100
You can use following DAX to create quarterwise data:
Quarter = IF(AND('Table'[Hourly Rate]>=0,'Table'[Hourly Rate]<=5), "Quarter 1",
IF(AND('Table'[Hourly Rate]>5,'Table'[Hourly Rate]<=10), "Quarter 2",
IF(AND('Table'[Hourly Rate]>10,'Table'[Hourly Rate]<=15),"Quarter 3",
IF(AND('Table'[Hourly Rate]>15,'Table'[Hourly Rate]<=100),"Quarter 4"))))
Thank you for your reply and assistance- I will try this solution 🙂