Calculate a measure that checks if data is blank and If so use previous montavg to do calcuations

[salim123]

Hello every one,

So I am new to dax and I am writing this measure that calculates a weighted value (SUMPROD(volume, TS) divided bySUM(Volume)), but the problem is that TS values are not there every day, so I have to multiply the volume with TS avg of the previuos month, I see that my reasoning is right bu something dosen't seem to work.
Here is My measure :

TS Ponderee (Madcap) =

        DIVIDE(

            SUMX('all years data',

            var c=0

            return

                 if('all years data'[T/S]<>BLANK(),'all years data'[Vol L]*'all years data'[T/S], 'all years data'[Vol L]*[previous_month_ts])

            ),

            SUMX(

                'all years data', 'all years data'[Vol L]

            )

        )

The previous month measure:

previous_month_ts = Calculate(

                        [T/S avg],

                        DATEADD(DateAnalyse[Date],-30,DAY)

                    )

Here is a piece of my data , as you can T/S is not there every time:

And here what I get when I show data as a table:

Any remark would be helpful.
thank you

[Greg_Deckler]

@salim123 Can you post your data and measure formulas as text?

[salim123]

Thank u Greg for ur feedback, I just did. thanks

[v-yadongf-msft]

Hi @salim123 ,

Has your problem been solved? If solved, please consider Accept it as the solution to help the other members find it more quickly.

Best regards,

Yadong Fang