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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
85 | |
78 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |