convert dax query to sql query

Hey shabanashaik88 

Try this:

WITH MinMax AS (
    SELECT
        MFCName,
        MIN(MachineHours) AS MinHours,
        MAX(MachineHours) AS MaxHours
    FROM MFC_FC_TREND_ANALYSIS_VIEW
    GROUP BY MFCName
),
Buckets AS (
    SELECT
        MFCName,
        MinHours,
        MaxHours,
        (MaxHours / 20) AS MinBucket,
        (MaxHours / 20) * 2 AS a,
        (MaxHours / 20) * 3 AS b,
        (MaxHours / 20) * 4 AS c,
        (MaxHours / 20) * 5 AS d,
        (MaxHours / 20) * 6 AS e,
        (MaxHours / 20) * 7 AS f,
        (MaxHours / 20) * 8 AS g,
        (MaxHours / 20) * 9 AS h,
        (MaxHours / 20) * 10 AS i,
        (MaxHours / 20) * 11 AS j,
        (MaxHours / 20) * 12 AS k,
        (MaxHours / 20) * 13 AS l,
        (MaxHours / 20) * 14 AS m,
        (MaxHours / 20) * 15 AS n,
        (MaxHours / 20) * 16 AS o,
        (MaxHours / 20) * 17 AS p,
        (MaxHours / 20) * 18 AS q,
        (MaxHours / 20) * 19 AS r
    FROM MinMax
)
SELECT 
    v.MFCName,
    v.MachineHours,
    CASE 
        WHEN v.MachineHours IS NULL THEN NULL
        WHEN v.MachineHours BETWEEN b.MinHours AND b.MinBucket THEN b.MinBucket
        WHEN v.MachineHours > b.MinBucket AND v.MachineHours <= b.a THEN b.a
        WHEN v.MachineHours > b.a AND v.MachineHours <= b.b THEN b.b
        WHEN v.MachineHours > b.b AND v.MachineHours <= b.c THEN b.c
        WHEN v.MachineHours > b.c AND v.MachineHours <= b.d THEN b.d
        WHEN v.MachineHours > b.d AND v.MachineHours <= b.e THEN b.e
        WHEN v.MachineHours > b.e AND v.MachineHours <= b.f THEN b.f
        WHEN v.MachineHours > b.f AND v.MachineHours <= b.g THEN b.g
        WHEN v.MachineHours > b.g AND v.MachineHours <= b.h THEN b.h
        WHEN v.MachineHours > b.h AND v.MachineHours <= b.i THEN b.i
        WHEN v.MachineHours > b.i AND v.MachineHours <= b.j THEN b.j
        WHEN v.MachineHours > b.j AND v.MachineHours <= b.k THEN b.k
        WHEN v.MachineHours > b.k AND v.MachineHours <= b.l THEN b.l
        WHEN v.MachineHours > b.l AND v.MachineHours <= b.m THEN b.m
        WHEN v.MachineHours > b.m AND v.MachineHours <= b.n THEN b.n
        WHEN v.MachineHours > b.n AND v.MachineHours <= b.o THEN b.o
        WHEN v.MachineHours > b.o AND v.MachineHours <= b.p THEN b.p
        WHEN v.MachineHours > b.p AND v.MachineHours <= b.q THEN b.q
        WHEN v.MachineHours > b.q AND v.MachineHours <= b.r THEN b.r
        ELSE b.MaxHours
    END AS Bucket
FROM 
    MFC_FC_TREND_ANALYSIS_VIEW v
JOIN 
    Buckets b ON v.MFCName = b.MFCName

Keep in mind that this example assumes a simplified structure of your database, and the exact query might vary depending on your specific database schema and SQL dialect.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube