Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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+"
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |