Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am moving a report from Tableau into Power BI. I am having some trouble recreating the fomulas, as the syntax is different. How would I write this Tableau calcuation in Power BI:
IF [Include Admin Schedule Hrs] AND NOT(ISNULL([AdminSchedHours]))
THEN
IIF(ISNULL([Worked Hours]), MIN([AdminSchedHours], IIF(ISNULL([MedianExpectedTaskHours]), 8,NULL ) ) , [Worked Hours])
@Anonymous , A measure like this
IF ( [Include Admin Schedule Hrs]>0 && NOT(isblank([AdminSchedHours])), IF(isblank([Worked Hours]), MIN([AdminSchedHours]), IF(ISNULL([MedianExpectedTaskHours]), 8,NULL ) )
, [Worked Hours])
Thank you for your help. I am getting an error, it doesn't like ISNULL
Included Admin Schedule Hrs (Adj) = IF(NOT(ISBLANK('CRNA Time Management'[AdminSchedHours])), IF(ISBLANK('CRNA Time Management'[WorkedHours], MIN('CRNA Time Management'[AdminSchedHours]),IF(ISNULL('CRNA Time Management'[MedianExpectedTaskHours]),8,NULL)), 'CRNA Time Management'[WorkedHours]))
I revised to this, think it's OK
Included Admin Schedule Hrs (Adj) = IF(NOT(ISBLANK('CRNA Time Management'[AdminSchedHours])), IF(ISBLANK('CRNA Time Management'[WorkedHours]), MIN('CRNA Time Management'[AdminSchedHours]),IF(ISBLANK('CRNA Time Management'[MedianExpectedTaskHours]), 8, 0)), 0)
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |