Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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+"
)