Power BI DAX help needed
Budget: $10 – $30 USD
I have 2 tables.
Table A includes Names, Dates, and Procedures.
Table B assigns Ranks to each Procedure.
Tables are associated by Procedure Name
I need a count of Procedures based on Names, Date, and Rank of Procedure so that it only counts the lowest value Rank if multiple procedures were done on the same day for the same Name.
I have included a sample pbix file and excel desired results.
Table A includes Names, Dates, and Procedures.
Table B assigns Ranks to each Procedure.
Tables are associated by Procedure Name
I need a count of Procedures based on Names, Date, and Rank of Procedure so that it only counts the lowest value Rank if multiple procedures were done on the same day for the same Name.
I have included a sample pbix file and excel desired results.
Related categories:
Power BI