Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

YTD calculations - no date table

hi all,     I have data in the following format.   I want to specify from 2018-Q1 to 2018-Q2, sum all company units and divide by total market units. Aka. YTD, how can i do this with periods th...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    i created a new comlumn in the edit query, based on the text date column.

     

    2018-Q1 to 2018-01

    2018-Q2 to 2018-04

    2018-Q3 to 2018-07

    2018-Q4 to 2018-10

     

    and made this new column defined as date, it worked but seems like a suboptimal solution.

     

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Anonymous

Is the "Period" column a text type column or date type?

I'm afraid if your dataset doesn't contain any date column, it is not posssible to do YTD calculations.

You could create new date columns according to "Period" column, thus you could do YTD calculations.

 

Best Regards

Maggie

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    i created a new comlumn in the edit query, based on the text date column.

     

    2018-Q1 to 2018-01

    2018-Q2 to 2018-04

    2018-Q3 to 2018-07

    2018-Q4 to 2018-10

     

    and made this new column defined as date, it worked but seems like a suboptimal solution.