Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Group data based on days difference

Hi Guys,   I have some data with date fields.   What I want to do is get the difference between these 2 days and group it under grouping table based on the number of days. And the result should ...
  • KasunManchanaya's avatar
    KasunManchanaya
    4 years ago
    Please check this.

    Delay Hours =
    var __minval =
    SELECTEDVALUE('Grouping'[Min])
    var __maxval =
    SELECTEDVALUE('Grouping'[Max])
    var __datatable =
    CALCULATETABLE(
    'Data',
    'Data'[Plan Vs Actual] = "Delayed"
    )
    var __answer =
    CALCULATE(
    COUNT('Data'[Order Number]),
    FILTER(
    'Data',
    'Data'[Column1] >= __minval &&
    'Data'[Column1] <= __maxval
    ),__datatable
    )
    return
    __answer
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Not giving the expected Answer.

KasunManchanaya's avatar
KasunManchanaya
Regular Visitor
4 years ago
Please check this.

Delay Hours =
var __minval =
SELECTEDVALUE('Grouping'[Min])
var __maxval =
SELECTEDVALUE('Grouping'[Max])
var __datatable =
CALCULATETABLE(
'Data',
'Data'[Plan Vs Actual] = "Delayed"
)
var __answer =
CALCULATE(
COUNT('Data'[Order Number]),
FILTER(
'Data',
'Data'[Column1] >= __minval &&
'Data'[Column1] <= __maxval
),__datatable
)
return
__answer