Simple 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.
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 1 Name.
I have included sample data and desired results.
Table A includes Names, Dates, and Procedures.
Table B assigns Ranks to each Procedure.
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 1 Name.
I have included sample data and desired results.
Related categories:
Power BI