Forum Discussion
DAX Help
Please I need help converting the SQL Code below to Power BI DAX. a and b aliases are for different tables respectively. Thank you. (((COUNT(a.[Case ID])*365/MAX(b.[Days in Month])))/(MAX(b.Membe...
Iyke4joe - Yep, understood, sample data is great. And what is the expected output from the sample data you provided? Once I understand that, should be able to mock this up in a PBIX for you.
Here's the explanation I got for the code. Will this help?
| Metric | Membership | Days in Year | Days in Month | Formula | Comment | Solution/ K |
| 315 | 12821 | 365 | 31 | =(A2*C2/D2)/(B2/1000) | (metric * Days in Year/Days in Month)/(Membership/1000) ; Goes down to days and helps in Feb since it has fewer days | 289.28 |