Filter last month BUT ON THE EXISTING MEASURE, not on a variable

[ricardorc7]

Hello guys, I am seeing a lot of how to create a DAX for the last 30 days, and for that we use CALCULATE (SUM ([a variable like Sales or Cost]..........

I want to filter the last 30 days of an existing DAX that is actually a weighted average - in my example, I have on the main datasource revenues and volume, my DAX (called it Weighted average) is to give me the USD/ton or weighted average.

Now how can I get the last 30 days of that existing DAX? If I use CALCULATE (SUM OR AVERAGEX) it won't be the weighted average in which the DAX Weighted average manages to do...

thanks!

[v-xiaotang]

Hi @ricardorc7 

Thanks for reaching out to us.

>> Now how can I get the last 30 days of that existing DAX? 

🤔🤔 My suggestion is to create a new measure, please share your sample data and expected results in the form of pictures, thanks

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.