Calculation in Tableau to PowerBI

[snemilipuri]

Can anyone please help to convert the below Tableau logic to Power BI logic

Tableau Logic=

[ID]=

(if
[Timestamp]= {FIXED [Block],[Indicator],DATEPART('week',[Timestamp]),[Entry]:
MAX(if NOT ISNULL([Value]) THEN [Timestamp] END)}

THEN

{FIXED [Block],[Indicator],[Entry],[Timestamp]:MAX([ID])}

END)

[v-jayw-msft]

Hi @snemilipuri ,

I am not familiar with Tableau, can you explain the logic of your formula? Or you could share some sample data and expected result to us.

Best Regards,

Jay

[parry2k]

@snemilipuri we don't know what that Tableau formula suppose to return. You should paste sample data and 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