Reporting on 1st occurences in a Fiscal Year

[Karolina411]

Hello -- I created a distinct count measure and added it to a table with my own fiscal year and fiscal and fiscal quarter. My goal was to determine the first visit for each patient in a fiscal year and then report which quarter the first visit occurred. The table I created does a unique count for each quarter the patient was seen, it does not report the quarter in which that first fiscal year visit occurred.

I found this example but do not seem to b selecting the correct values.  Do you have any suggestion how I could use Dax to id each occurence then output the # of the Fiscal Quarter of the 1st patient appointment.

[v-yueyunzh-msft · Accepted solution]

Hi, @Karolina411 

Based on your description, you want to get the quarter of the first patient appointment. First for you to group something, you can put the field in the visual, then for the earliest quarter you need to create a quarter time identifier for your Date column to determine which quarter is the oldest, you can use the FILTER() function to filter out all records of that patient, and then use the MINX() function to locate the earliest quarter.

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[ryan_mayu]

could you pls provide some sample data and expected output?