ProductX for Measure not Working

[quickcreator]

I have 2 tables, cash & assets. I made a measure: (current months’s assets – current month’s cash)/previous month’s assets. It gives me a % return, which is great. However, I’m trying to get a running return by month but nothing is working. I’ve tried the ProductX on this % measure, but it comes up blank. I’ve also tried the Calc(ProductX…Filter(…<=Max, but it grabs everything from the beginning up to my slicer value. I just need a value for a specific date range. Any ideas how to get ProductX to work on this measure?

[Anonymous]

Who do u means by productx measure.

Whenever you ask question on community please share some sample data and expected output.

Thanks,
Pravin

[quickcreator]

Hi Pravan.  The pic & DAX is posted as a pic above. Thanks for your help!

[Anonymous]

try this,

i think % return should be column so that the formula will work.

Calculate(productx(table,1+table[rate%]),filter(all(table),table [date]< max(table[date]))

Thanks,

Pravin

[quickcreator]

Thanks, but it %Return is not a column. It is a measure based on filtering from the Cash & Assets table. I need a ProductX based on a Measure, please.  Thanks for your continued investigation on this.

[Anonymous]

Try this,

MEasure=

Var table=Summerize(table1,date,"rate",[Rate %])

return

Calculate(productx(table,1+[rate]),filter(all(table),[date]< max([date]))

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[quickcreator]

Thanks, but I don't have a fixed Table. I have a resulting dynamic matrix from the combination of the Cash & Assets table, then it is filtered by Investment & Date. Thanks for trying.

[AlB]

Hi @quickcreator 

Can you please share an example based on data, so that it is easier to understand what you are after? Ideally, share a mock pbix

Cheers

[quickcreator]

Here's the screen shots. Let me know if this makes sense.  Thanks so much for your help!

[quickcreator]

[BrenoPin]

Hello, I am trying to do something similar, did you find a solution?

[quickcreator]

What in particular are you trying to solve?

[Brenoo]

A PRODUCTX from a measure. Samething from your problem I have a measure that return me the Rate% and need to do a ProductX from that Rate%. How did you solve your problem?