alternate of fixed function in power bi

[Anonymous]

I am trying to integrate tableua dashboad  to power bi.

How can i convert the below query in tableua in to DAX measure.

IIF([Sys Created On]={FIXED[Number]:MAX([Sys Created On]) },"TRUE","FALSE"

[V-pazhen-msft · Accepted solution]

@Anonymous 

For the level of detail expression, you are correctly transformed to dax. However, to put everything in one column, you can just add a simple IF function, IF function (DAX) - DAX | Microsoft Docs.

Column = 
var calculated_test = CALCULATE(MAX(v_Daily_SNOW_Kanban[sys_created_on]),ALLEXCEPT(v_Daily_SNOW_Kanban,v_Daily_SNOW_Kanban[Number]))

Return IF([Sys Created On]= calculated_test, True(), False())

But the above dax is a column formula, to create a measure you may use this dax:

Measure= 
var calculated_test = CALCULATE(MAX(v_Daily_SNOW_Kanban[sys_created_on]),Filter(Allselected(v_Daily_SNOW_Kanban),v_Daily_SNOW_Kanban[Number]=MAX(v_Daily_SNOW_Kanban[Number]))

Return IF(MAX([Sys Created On])= calculated_test, True(), False())

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , I covered that in this video -See if that can help

Tableau Vs Power BI- Chapter 6- LOD- FIXED (Level of Details)

https://www.youtube.com/watch?v=QdnOHcZqkPU

[Anonymous]

Hi Amit,

I tried with you provided the solution in youtube but i am still getting some issue.

Calculated_test = CALCULATE(MAX(v_Daily_SNOW_Kanban[sys_created_on]),ALLEXCEPT(v_Daily_SNOW_Kanban,v_Daily_SNOW_Kanban[Number]))

i am getting the correct max of date from sys_created_on using allexcept filter with numbers.

but i need  another column column to compare the calculated_test with the sys_cretaed_on is matched then true else false.

Could you please help me.