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