To Convert tableau calculation to PBI DAX

[Aafiya]

I am migrating Tableau reports to Power BI

IF [SORT]='LAST UPDATE' THEN

DATEPART('hour',{fixed [VEHICAL NO]:max([Time])})+DATEPART('minute',{fixed [VEHICAL NO]:max([Time])})/60

ELSE

{fixed [VEHICAL NO]:sum([Delay Hours])}

END

Trying to replicate above tableau calculation into Power BI DAX.

[Anonymous]

Hi @Aafiya ,

Please have a try.

Create a column.

Column =
IF (
    TableauData[SORT] = "LAST UPDATE",
    HOUR (
        MAXX (
            FILTER (
                TableauData,
                TableauData[VEHICAL NO] = EARLIER ( TableauData[VEHICAL NO] )
            ),
            [Time]
        )
    )
        + MINUTE (
            MAXX (
                FILTER (
                    TableauData,
                    TableauData[VEHICAL NO] = EARLIER ( TableauData[VEHICAL NO] )
                ),
                [Time]
            )
        ) / 60,
    SUMX (
        FILTER (
            TableauData,
            TableauData[VEHICAL NO] = EARLIER ( TableauData[VEHICAL NO] )
        ),
        [Delay Hours]
    )
)

 Or a measure.

Measure =
IF (
    SELECTEDVALUE ( TableauData[SORT] ) = "LAST UPDATE",
    HOUR ( MAX ( ALLEXCEPT ( TableauData, TableauData[VEHICAL NO] ), [Time] ) )
        + MINUTE ( MAX ( ALLEXCEPT ( TableauData, TableauData[VEHICAL NO] ), [Time] ) ) / 60,
    SUMX ( ALLEXCEPT ( TableauData, TableauData[VEHICAL NO] ), [Delay Hours] )
)

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

[parry2k]

@Aafiya you should post a sample data explaining the expected output. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490