Forum Discussion

ssai23's avatar
ssai23
New Member
6 years ago

Convert Tableau LOD to Power bi equivalent

This is a very critical tableau LOD calculation which i am finding very difficult to covert to power bi. i have tried ALLEXPECT function but dont know how and where to put the conditions like in the below tableau LOD calculation. thanks

 

{ FIXED [Plan Id]: MAX(IF [Act Name] = 'Remote Connectivity Test'
OR [Act Name] = 'Confirm equipment is connected' THEN [Act Business Cycle Time] ELSE 0 END )}
+
{ FIXED [Plan Id]: MAX(IF [Act Name] = 'Activate Physical (Layer 2) Components' THEN [Act Business Cycle Time] ELSE 0 END )}
+
{ FIXED [Plan Id]: MAX(IF [Act Name] = 'Complete the Layer 2 Design' THEN [Act Business Cycle Time] ELSE 0 END )}
+
{ FIXED [Plan Id]: MAX(IF [Act Name] = 'Confirm Customer & Site Ready for Install' THEN [Act Business Cycle Time] ELSE 0 END )}
+
{ FIXED [Plan Id]: MAX(IF [Act Name] = 'Confirm Readiness for Equipment Recovery' THEN [Act Business Cycle Time] ELSE 0 END )}
+
{ FIXED [Plan Id]: MAX(IF [Act Name] = 'Deactivate Physical (Layer 2) Components' THEN [Act Business Cycle Time] ELSE 0 END )}
+
{ FIXED [Plan Id]: MAX(IF [Act Name] = 'Recover the Equipment' THEN [Act Business Cycle Time] ELSE 0 END )}