Convert Measure into a column

[DYY94]

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 'dates' into column first ! 

Any Ideas ? 

This is my measure : 

dates = 
VAR str = SELECTCOLUMNS(BTA_Output,"d",BTA_Output[Maturite])&"-"&[MR/365]
VAR _date =
    FORMAT (SELECTCOLUMNS(BTA_Output,"d",BTA_Output[Maturite]), "yyyy/mm/dd" )
VAR _num =
    [MR/365] 
VAR _cal =
    "-"
VAR tmp =
    FILTER (
        ALL ( 'Date' ),
        YEAR ( [Date] )
            > YEAR ( _date ) - _num
            && YEAR ( [Date] ) < YEAR ( _date )
            && MONTH ( [Date] ) = MONTH ( _date )
            && DAY ( [Date] ) = DAY ( _date ) 
    )
VAR _a =
    CONCATENATEX ( tmp, [Date], "
" )
RETURN
    SWITCH ( TRUE (), _cal = "-", _a )

Output: 

 

Thanks ! 

[daXtreme]

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]

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.