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 that are in Quarters? I have deselected the time-intelligence in options.

Also, if i have sales data by week or month, how can i do similar YTD calculations without having dates?

 

 

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.

     

2 Replies

  • 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.