Forum Discussion

Regnbagar1's avatar
Regnbagar1
Icon for Helper I rankHelper I
4 years ago
Solved

Create a calculated column for a specifik date range

Hi, I need help with creating a calculated column in my date table, "Date_tabel". I would like to have 1 if it is between last 25:th and the 25:th before that otherwise 0.  For example: 1. Tod...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Regnbagar1 ,

    Please refer to my pbix file to see if it helps you. 

    Create a column.

    Column =
VAR _previous1 =
    DATE ( YEAR ( EDATE ( TODAY (), -1 ) ), MONTH ( EDATE ( TODAY (), -1 ) ), 25 )
VAR _previous2 =
    DATE ( YEAR ( EDATE ( TODAY (), -2 ) ), MONTH ( EDATE ( TODAY (), -2 ) ), 25 )
RETURN
    IF (
        'Table'[date] > _previous2
            && 'Table'[date] <= _previous1,
        1,
        IF ( TODAY () >= _previous1, 0, BLANK () )
    )

    If I have misunderstood your meaning, please provide your desired output and your pbix without privacy information.

     

    Best Regards

    Community Support Team _ Polly

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Regnbagar1 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.