Forum Discussion
Anonymous
4 years agoNot applicable
Power BI DAX
I need to convert this Tableau fnction into dax..
Percentage diff = COUNTD([Completed Visits])/SUM([Fixed Visit Count]),
fixed visit Count =
{ FIXED YEAR ([START_DATE]),[FINANCIAL_CODE],[Region Breakdown],[PRIM_CODE]: COUNTD([VISIT_NO])}
i need to find this fixed visit count then i want to calculate percentage diff.
i need to find this fixed visit count then i want to calculate percentage diff.
5 Replies
- parry2k
Super User
Anonymous better to share sample data and the expected output. Not necessarily people know what Tableau formulas are doing.
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- AnonymousNot applicable
i have attached the data
- AnonymousNot applicable
- parry2k
Super User
Anonymous unfortunately it doesn't help. It is a screenshot from Tableau, and I have no idea what I'm looking at. As suggested post a sample data and the expected output.
- AnonymousNot applicable