Forum Discussion

yellow43's avatar
yellow43
Icon for Helper I rankHelper 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 i...
AlanFredes's avatar
AlanFredes
Icon for Resolver IV rankResolver 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!