DAX: Measure to Calculated Column

[Anonymous]

Hi all,

I'm trying to create a calculated column from this measure:

Build Up 3 Months = CALCULATE(SUM('Demand Waterfall'[DP Dollar]), FILTER('Demand Waterfall', MONTH('Demand Waterfall'[Waterfall Date]) = MONTH(MAX('Demand Waterfall'[Year Month])))) + CALCULATE(SUM('Demand Waterfall'[DP Dollar]), FILTER('Demand Waterfall', MONTH('Demand Waterfall'[Waterfall Date]) = MONTH(MAX('Demand Waterfall'[Year Month]))+1)) + CALCULATE(SUM('Demand Waterfall'[DP Dollar]), FILTER('Demand Waterfall', MONTH('Demand Waterfall'[Waterfall Date]) = MONTH(MAX('Demand Waterfall'[Year Month]))+2)) - SUM('Final Unconsumed Demand'[Total Final Unconsumed Dd Amt (USD)])

Thank you in advance!

[V-pazhen-msft · Accepted solution]

@Anonymous \

You can use earlier to filter sum([DP dollar]) by month.

Build Up 3 Months =
CALCULATE(SUM('Demand Waterfall'[DP Dollar]), FILTER('Demand Waterfall', MONTH('Demand Waterfall'[Waterfall Date]) = EARLIER(MONTH('Demand Waterfall'[Year Month]))))

+ CALCULATE(SUM('Demand Waterfall'[DP Dollar]), FILTER('Demand Waterfall', MONTH('Demand Waterfall'[Waterfall Date]) = EARLIER(MONTH('Demand Waterfall'[Year Month]))+1))

+ CALCULATE(SUM('Demand Waterfall'[DP Dollar]), FILTER('Demand Waterfall', MONTH('Demand Waterfall'[Waterfall Date]) = EARLIER(MONTH('Demand Waterfall'[Year Month]))+2))

- 'Final Unconsumed Demand'[Total Final Unconsumed Dd Amt (USD)]

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[richbenmintz]

Hi @Anonymous , 

Would you be able to provide, sample data, expected results, and a sample .pbix, would go a long way in helping the community get this question answered for you.

Thanks