Rated/Non-Rated (Points or No points) based on Date

[asmita_sharma]

Hi, 

I am trying to find the total no of rated and non-rated based on the JDEG's number from the Master Sheet with the relevant different sheets:

Master Spreadsheet:

The JDE Number is a unique value and so is the 'Company' column - and this has no dates

However the second spreadsheet X has date associated with it.

So not all the JDE number is present in the Master Spreadsheet that means not all the company has total points.

I'm trying to figure out a way, if on a yearly basis - which companies have points and which doesn't (naming them rated and non-rated).

I hope this made sense.

The relationship is based on the JDE number in the sheet here.

[v-easonf-msft · Accepted solution]

Hi, @asmita_sharma 

You can take a try formula as below:

Measure1 = 
VAR _total =
    MAX ( Table2[Total Point] )
RETURN
    IF ( ISBLANK ( _total ), "non-rated", "rated" )

If it doesn't meet your requirement, please share more details.

Best Regards,
Community Support Team _ Eason

[asmita_sharma]

The agenda is to put the date as slicer and check for the rated/non-rated.