Forum Discussion

yodha's avatar
yodha
Icon for Helper IV rankHelper IV
6 years ago
Solved

Add future month Date to Current Date

In my data source i have a column "Count" and i am generating "Date" Column by using "DateTime.LocalNow()". now i want to create one more table with same "Count" Column , but "Date" as 01/07/2...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi yodha ,

     

    Firstly, you may enter into Query Editor,  select on your query, go to Add column ->Custom column, type codes as below to create two columns [Current Date] and [Future Date] .

     

    DateTime.LocalNow()

     

    Date.AddDays([Current Date], 30)

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Secondly, you may select on the two date columns at the same time, right click to choose option "Unpivot Columns", rename the new result column Value with "Date".

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi yodha ,

 

Firstly, you may enter into Query Editor,  select on your query, go to Add column ->Custom column, type codes as below to create two columns [Current Date] and [Future Date] .

 

DateTime.LocalNow()

 

Date.AddDays([Current Date], 30)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Secondly, you may select on the two date columns at the same time, right click to choose option "Unpivot Columns", rename the new result column Value with "Date".

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.