Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi everyone,
I hope you are all safe and well.
Im fairly new to DAX and Power BI, I have the following table below
| TheWeek | Received date | Processed date | DateDiff |
| 33 | 2021-08-09 | 2021-08-10 | 1 |
| 33 | 2021-08-10 | 2021-08-11 | 1 |
| 33 | 2021-08-12 | 2021-08-13 | 1 |
| 33 | 2021-08-09 | 2021-08-11 | 2 |
| 33 | 2021-08-11 | 2021-08-13 | 2 |
| 33 | 2021-08-10 | 2021-08-13 | 3 |
| 33 | 2021-08-13 | 2021-08-16 | 3 |
| 33 | 2021-08-09 | 2021-08-13 | 4 |
The column DataDiff is the gap between the Received date and Processed date. What I want to do is to group the DiffGap that are 1-2, 3-4 and 5+ and show in a bar graph where the X axis is the week and the bars are 1-2, 3-4 and 5+.
So in this example we would have for the week 33 the 1-2 range with count of 5 and for the range 3-4 with the count of 3.
Thank you in advance,
Solved! Go to Solution.
@Ikezaki You could do this:
Group Column =
SWITCH(TRUE(),
[dateDateDiff] < 3,"1-2",
[dateDateDiff] < 5,"3-4",
"5+"
)
@Ikezaki You could do this:
Group Column =
SWITCH(TRUE(),
[dateDateDiff] < 3,"1-2",
[dateDateDiff] < 5,"3-4",
"5+"
)
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!