random82/ytd-total-budget.md

Last active December 19, 2018 01:46

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/random82/6a94e7fb110e35551a7af39efe6196cc.js"></script>
Save random82/6a94e7fb110e35551a7af39efe6196cc to your computer and use it in GitHub Desktop.

DAX Pattern - % Actual YTD over total budget

Raw

    % Actual vs Budget YTD OPEX = 
IF(
	ISFILTERED('Calendar'[Date]),
	ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
	DIVIDE(
	TOTALYTD(
	    SUM('OPEX'[Actual]),
	    'Calendar'[Date].[Date]
	),        
	CALCULATE(
	    SUM('OPEX'[Budget]),
	    ALL('OPEX')
	)        

)


  