Forum Discussion

yellow43's avatar
yellow43
Helper I
3 years ago

Create new colum comparing value in same column

Hi Community,

 

Probably this is easy to solve, but I am having some problems.

I would like to cretae a new column with this conditions:

- between dates 1/1/2023 and 31/3/2023

- check if value is the same in the column

- create new column if value is the same in the column and if it was created  between dates above. 

 

Here is the result expected for new column [New2023?]:

 

 

Product=Pasta is the one that is in different rows and that match conditions above.

Can you help me?

Thank you. 

 

1 Reply

  • AlanFredes's avatar
    AlanFredes
    Resolver IV
    3 years ago

    Hi Yellow,

     

    A calculated column that evaluates if the Product value is duplicated and within the data range you need would work.
    Something like the bellow code:

    New 2023 =
    VAR Current_Val = 'Data table'[Product]
    VAR Start_Date = DATE(2023,1,1)
    VAR End_Date = DATE(2023,3,31)
    VAR Duplicate =
        COUNTROWS(
            FILTER(
                'Data table',
                'Data table'[Product]=Current_Val
            )
        )
    VAR Check_Date = IF('Data table'[Created at]>=Start_Date && 'Data table'[Created at]<=End_Date,1,0)
    RETURN
    IF(Duplicate=2 && Check_Date=1,1,0)

     


    You can find the example in this file: Create new colum comparing value in same column.pbix

     

    Did I answer your question? Mark my post as a solution!