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 '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 ! 

Need Help

2 Replies

  • 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.