Forum Discussion

Brynut's avatar
Brynut
Frequent Visitor
7 years ago

Set data set to current half

Hi, Might be a simple one but I have not been able to find anything on the community or google. In Power Query Editor I want to filter the data set to the current half, I only have options in the st...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

Brynut ,

 

What does "Current Half" mean? Could you please share some more details about your requirement and post some sample data?

 

Regards,

Jimmy Tao

  • Brynut's avatar
    Brynut
    Frequent Visitor
    7 years ago

    Hi,

    Sorry for the delay.

    Without wanting to change my original question too much, all I want is the ability to include half years in the date hierachy, for eaxmple... Year,Half,Quarter,Month,Day.

    Is there an easy way to achieve this?

    Thanks,

    Simon

     

    • v-yuta-msft's avatar
      v-yuta-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      Brynut ,

       

      You need to build the custom hierarchy, please refer to tutorials below:

      https://www.youtube.com/watch?v=q8WDUAiTGeU

       

      Community Support Team _ Jimmy Tao

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

    • v-yuta-msft's avatar
      v-yuta-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      Brynut ,

       

      I'm afraid currently the built-in date hierarchy doesn't contains "half". I would suggest you to build custom hierarchy, please refer to video below:

      https://www.youtube.com/watch?v=WWvVeYU0Dvw

       

      Community Support Team _ Jimmy Tao

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