Hello,
I would like to calculate the percent of sales within each month,
But this is not what I want , I want to access the Month from the hierarchy not 'dates', but I need Month, in Power query the option is available even if you only initially start with a date column, or is there a way to get to the Month?
Richard.
[/CODE]
I would like to calculate the percent of sales within each month,
Excel Formula:
Monthly % =
VAR num = [Total Sales]
VAR den = CALCULATE([Total Sales],ALLEXCEPT(Alls,Alls[Dates]) )
VAR anser = DIVIDE(num , den )
RETURN anser
But this is not what I want , I want to access the Month from the hierarchy not 'dates', but I need Month, in Power query the option is available even if you only initially start with a date column, or is there a way to get to the Month?
Richard.
Excel Formula:
[CODE=vba]