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.