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,

Thanks for the link. I am happy with setting up hierachies, I have also worked out how to have a measure for half, quarter, month and day. The problem I am still getting is the ordering of the months, for example April then shows before January etc. Does that make sense?

Thanks,

Simon