Forum Discussion
Need help with date gap
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,
Anonymous You could do this:
Group Column = SWITCH(TRUE(), [dateDateDiff] < 3,"1-2", [dateDateDiff] < 5,"3-4", "5+" )
1 Reply
- Greg_Deckler
Community Champion
Anonymous You could do this:
Group Column = SWITCH(TRUE(), [dateDateDiff] < 3,"1-2", [dateDateDiff] < 5,"3-4", "5+" )