totalytd incorrect

Solved: Combining data - Microsoft Power BI Community

Hi all, 

I had earlier an issue with combining data which was solved by speedramps in the above topic and for which you find the details below.

To combine my data, the following measure was created :

Your answer = 

IF(ISEMPTY[YTD]),
SUM(LE[actual]),
SUM(ACTUALS[actual])
)

Now I would like to create a YTD measure. I have created the following measure, but it only shows YTD values until April. From May onwards, it shows the actuals per month. 

YTD = totalytd([your answer], 'Calendar'[Date])

Any idea what I do wrong?

I had earlier an issue with combining data which was solved in the above topic. Now from there I would like to create a YTD table.

Hi all,

I have the following 2 tables :

I would like to create a measure or calculated column where I combine data based on period data from another table with the conditition that IF the Actuals[period] occurs in the below table (ytd period), it should take the actuals of ACTUALS. If the period doesn't appear in ytd period, it should take the period and actuals of LE.

End result :

Now I would like to create a YTD of the measure 

Your answer = 

IF(ISEMPTY[YTD]),
SUM(LE[actual]),
SUM(ACTUALS[actual])
)