Forum Discussion

AJ007's avatar
AJ007
Icon for Helper I rankHelper I
8 years ago
Solved

Default Date from Month and Year

I have a test dataset with only 3 columns. Column1 has sales value, Column2 has month name (e.g. January), Column3 has year (e.g. 2016)   My final goal is to calculate running total for each year (...
Need Help
  • RolandsP's avatar
    RolandsP
    8 years ago

    You have to do following manipulation in Query editor with your month and year columns:

     

    1) Select Month and Year column, right click mouse and select Merge columns

    2) Select the new Merged column and change data type to Date (from small right icon on Column header).  You should get start of month date. This should be enough for your calculations.

    3) If you would like to get End of month date, you select Transform tab -> Date from Date&Time Column -> select Month and End of Month

RolandsP's avatar
RolandsP
Icon for Resolver IV rankResolver IV
8 years ago

You have to do following manipulation in Query editor with your month and year columns:

 

1) Select Month and Year column, right click mouse and select Merge columns

2) Select the new Merged column and change data type to Date (from small right icon on Column header).  You should get start of month date. This should be enough for your calculations.

3) If you would like to get End of month date, you select Transform tab -> Date from Date&Time Column -> select Month and End of Month

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

Brilliant !!