DAX Operation for a mesure

[Ber001]

Dear,

I'm getting crazy with a simple operation.

Table Product

Culunm 1 is the key culumn with the name of the product

Column 2 is a date

Column 3 is Custom Column (Number) with the result of Date.Month (Date) in powerquery

Culumn 1      I     Date      I   Month

Product 1      I 1/2/2021   I     2

Product 2      I  3/4/2021  I     4

Then, I just want to add a mesure with a simple multiplication : Product[Month] * Month(Now())

But I canont use Product[Month] value... I don't know why.

When I write Product[...   I just can use the other mesures of my table but not the Column values...

I tried with Related() but it doesn't work either.

Thank you for your help

Bertrand

[Anonymous]

@Ber001 

Are you trying to create a measure or a calculated column? These are two different things. If you want a measure, then you have to describe how it should aggregate data when more than 1 row is visible in the context. You have not done it, so a measure can only be a mere guess...

[Jihwan_Kim]

Hi, @Ber001 

Please try the below measure.

new measure = SELECTEDVALUE('Table'[Month]) * MONTH(NOW())

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.