topic Re: I have tableau calculation and i want to convert in Power BI DAX in DAX Commands and Tips

I have tableau calculation and i want to convert in Power BI DAX

Anonymous — Thu, 11 Nov 2021 05:51:15 GMT

this is tableau calcalation and i want conver into dax

i need help on this..

IF LOOKUP(MIN([DCC]),0) = LOOKUP(MIN([DCC]),-1)
THEN DATEDIFF('day',LOOKUP(MIN([CR Status Changed Date]), -1), LOOKUP(MIN([CR Status Changed Date]), 0))
END

Re: I have tableau calculation and i want to convert in Power BI DAX

amitchandak — Thu, 11 Nov 2021 06:04:10 GMT

Anonymous , In tableau LOOKUP is a table calculation, which means you can go across visual rows. In Power bi, there is no equivalent. You have to perform calculation using row context

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Re: I have tableau calculation and i want to convert in Power BI DAX

v-cazheng-msft — Mon, 15 Nov 2021 08:49:44 GMT

Hi Anonymous

It looks like you would like to calculate the interval of CR Status Changed Date for same DCC. If so, you may try this Measure.

DateDiff_ =

VAR val =

SELECTEDVALUE ( 'Table'[CR Status Changed Date] )

VAR cur_date =

CALCULATE (

val,

FILTER ( ALL ( 'Table' ), 'Table'[DCC] = MAX ( 'Table'[DCC] ) )

)

VAR search_date =

CALCULATE (

MIN ( 'Table'[CR Status Changed Date] ),

FILTER ( ALL ( 'Table' ), 'Table'[DCC] = MAX ( 'Table'[DCC] ) )

)

RETURN

DATEDIFF ( search_date, cur_date, DAY )

Then, result should look like this:

Attached the pbix file as reference.

Best Regards,

Community Support Team _ Caiyun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If you still have problems on it or I misunderstand your needs, please feel free to let me know. Thanks a lot!