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

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