Forum Discussion
DAX Help
Hi Greg, thank you for your response. For the sake of security, I can't give the exact data but here's a typical representation of it.
Thank you in anticipation of your response.
Table A | |||
CaseID | MemberID | SaleDays | Date |
234 | cc1 | 4 | 3/6/2019 |
456 | cc2 | 3 | 4/12/2019 |
789 | cc3 | 9 | 5/19/2019 |
Table B | ||||
Member_id | Membership | Year | Month | Days in Month |
cc1 | 2 | 2019 | 3 | 3 |
cc2 | 3 | 2019 | 4 | 30 |
cc3 | 5 | 2019 | 5 | 31 |
cc4 | 9 | 2019 | 7 | 31 |
cc5 | 7 | 2019 | 8 | 31 |
Hey Greg, thanks for your response and I apologize for just getting back to you on this.
I have asked and could not get any right explanation for the logic behind the SQL code. I am just responsible to create report and dashboard on power BI using the Code provided by the DBA team. I ahve played with this in different ways to avoid using the end column but still end up needing to use it. If there's anyway you can help, I will appreciate this. I don't know if they are doing it per every 1000 membership( just a hunch). Pls help as this is the only thing holding me back from moving forward.
Thank you