Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Need help understand the DAX formula. I need to replicate this in tableau.
_session avg times =
var result = CALCULATE(AVERAGE(Invoices[Billed Hours]),FILTER(Invoices, Invoices[Appt Outcome] = "completed" || Invoices[Appt Outcome] = "consultation" || Invoices[Appt Outcome] = "intake completed" || Invoices[Appt Outcome] = "treatment navigation")
)
return
IF(ISBLANK(result),0,result)
It is averaging the 'Billed Hours'
where 'Appt Outcome' = "completed" OR "consultation" OR "intake completed" OR "treament navigation"
The return is just handling Power BI's default of saying "(Blank)" if there is no data. All the return is saying is if it is blank, give me 0, if not, return the average that was just comptued.
Thank you for your response.
So when i convert it into tableau
AVG(IF [Appt Outcome] IN ("completed","consultation","intake completed","treatment navigation") THEN [Billed Hours] END)
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |