Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Ikezaki
Frequent Visitor

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

TheWeekReceived dateProcessed dateDateDiff
332021-08-09 2021-08-101
332021-08-10 2021-08-111
332021-08-12 2021-08-131
332021-08-09 2021-08-112
332021-08-11 2021-08-132
332021-08-10 2021-08-133
332021-08-132021-08-163
332021-08-092021-08-134

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,

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@Ikezaki You could do this:

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

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

@Ikezaki You could do this:

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

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.