Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Shift value in a column by Dax function

Hi all,   I would like to know Is there any function in Dax help shift values in a column. For example: Column 1 Column 2 Column 3 1 a a 2 b b 3 c c 4 d d 5 e e 6...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous 

Try this

create one column

if(table[Column1]<=4,Column2,Lookupvalue(table[Column2],table[Column1],table[Column1]-4)

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello Anonymous ,

     

    Can we express it as a Measure like DATEADD or PARALLELPRERIOD?

    In detail, I want to calculate a total Count with Previous Date Period but My data drilled down by Hour. When I use DATEADD or PARALLELPRERIOD, in thrown an exception because column date has duplicated value.

     

    My date by count like 

    TimeCount
    01/01/2018 10:00:00 PM4
    01/01/2018 11:00:00 PM2
    02/01/2018 12:00:00 AM2
    02/01/2018 01:00:00 AM6
    02/01/2018 02:00:00 AM4
    02/01/2018 03:00:00 AM9
    02/01/2018 04:00:00 AM0
    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Can You explain with the exact source and output?  not making it clear using two posts. Mark me @

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous 

         

        Your main question is differant than this now.

         

        Could you please share sample data and expected output.

         

        Thanks,

        PRavin