Forum Discussion

idontexist's avatar
idontexist
Icon for Helper I rankHelper I
8 years ago

Repeat values based on other value

Hi all,   I want to repeat values as you can see in column "should be plan". It should be based on column "Fact". If in this column there are any values so plan should be repeated. "Plan" i have 1 ...
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

idontexist,

 

You may refer to the following DAX.

Column =
VAR y =
    YEAR ( Table1[Date] )
VAR m =
    MONTH ( Table1[Date] )
RETURN
    IF (
        NOT ( ISBLANK ( Table1[Fact] ) ),
        LOOKUPVALUE (
            Table1[Plan],
            Table1[DSR Code], Table1[DSR Code],
            Table1[Date], DATE ( y, m, 1 )
        )
    )
  • idontexist's avatar
    idontexist
    Icon for Helper I rankHelper I
    8 years ago

    v-chuncz-msft

     

    formulae YEAR and MONTH want to get date in format. Not from column.

     

    So this isn't working for me :(