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 amitchandak ,

 

I am struggling with this case.

I current ly have a table like this.

TimeCountExpected (if shift 3 rows)
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 AM64
02/01/2018 02:00:00 AM42
02/01/2018 03:00:00 AM92
02/01/2018 04:00:00 AM06

How can I use DATEADD function with this table?

In my topic, you mentioned use 

Date = Table[timestamp].date

Could you please help me explain more how to use this?

I want to calculate a count shifted by specific days, just like DATEADD function.

 

Thank you for your help.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous 

 

Create one index column and add the formula which i have suggested.

 

I don't think using measures you can acheive this.

 

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

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