Forum Discussion

PowerBI87's avatar
PowerBI87
Frequent Visitor
6 years ago
Solved

Check if record exists

Hi All,   I was wondering if anyone had a solution for identifying new companies that have been added to my report?   For example, i would like a script to check the "Comapny" column to see if an...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi PowerBI87，

    If there is one field  that can identify new records (such as the date field in the below screen shot) in your table, it may be easier to obtain which companies are new or renewed. Just create a calculated column with the following formula:

    Renewal or New = 
VAR _countofC =
    CALCULATE (
        COUNT ( Company[Company] ),
        FILTER (
            ALL ( 'Company' ),
            'Company'[Company] = EARLIER ( 'Company'[Company] )
        )
    )
RETURN
    IF ( 'Company'[Date] = TODAY () && _countofC = 1, "New", "Renewal" )

    Best Regards

    Rena

     

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi PowerBI87，

If there is one field  that can identify new records (such as the date field in the below screen shot) in your table, it may be easier to obtain which companies are new or renewed. Just create a calculated column with the following formula:

Renewal or New = 
VAR _countofC =
    CALCULATE (
        COUNT ( Company[Company] ),
        FILTER (
            ALL ( 'Company' ),
            'Company'[Company] = EARLIER ( 'Company'[Company] )
        )
    )
RETURN
    IF ( 'Company'[Date] = TODAY () && _countofC = 1, "New", "Renewal" )

Best Regards

Rena