Forum Discussion
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 )}
1 Reply
- parry2k
Super User
ssai23 rather than putting tableau formula (which lots of us don't know), can you put sample data and expected result and you will get the answer. 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