Forum Discussion

DYY94's avatar
DYY94
Helper I
3 years ago

Convert Measure into a column

Hello Community,     I want to duplicate rows by Code_ISIN for each dates.  Each date in a row with the same Code_ISIN.  NB: Dates it's a measure !    So I thought to convert the Measure 'dat...
Need Help
daXtreme's avatar
daXtreme
Solution Sage
3 years ago

I don't know what it is you want... but this code

 

    FILTER (
        ALL ( 'Date' ),
        YEAR ( [Date] )
            > YEAR ( _date ) - _num
            && YEAR ( [Date] ) < YEAR ( _date )
            && MONTH ( [Date] ) = MONTH ( _date )
            && DAY ( [Date] ) = DAY ( _date ) 
    )

 

will most likely break on leap years... since February has variable number of days, not always the same.

 

By the way, measures are dynamic and react to selections. Columns are always static, so I don't quite get how you want to make a measure into a column...

  • DYY94's avatar
    DYY94
    Helper I
    3 years ago

    Hi daXtreme, 

    Thank you for answer. 

     

    - don't worry about the measure it works fine for me. But my probleme is i want to duplicate rows by Code_ISIN for each dates knowing that dates it's a measure. 

    - I want each date in a row with the same Code_ISIN ! 

     

    Thanks.