Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

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 202...

Need Help

Greg_Deckler

4 years ago

Anonymous You could do this:

Group Column =
  SWITCH(TRUE(),
    [dateDateDiff] < 3,"1-2",
    [dateDateDiff] < 5,"3-4",
    "5+"
  )

Greg_Deckler

Community Champion

4 years ago

Anonymous You could do this:

Group Column =
  SWITCH(TRUE(),
    [dateDateDiff] < 3,"1-2",
    [dateDateDiff] < 5,"3-4",
    "5+"
  )