DAX measure YTD based on Filter and without date column in visual - Error

[asfasfgasfg]

The measure I created only shows the entire year.

When I Filter the months I want it to show me the YTD value.

Last Year = CALCULATE(sum('Palmo_Transactions'[AmountFC]),filter(ALL('DateTable'),'DateTable'[Year]=[CurrentYear]-1))

Shows Entire year.

I need it to show YTD values but it gives me a placeholder error

Last Year = CALCULATE(sum('Palmo_Transactions'[AmountFC]),DATESYTD('DateTable'[DAY_DATE]),FILTER('DateTable',DateTable[Year]=([CurrentYear]-1)))

Can anyone help me with this please?

[Padycosmos]

 Hope this video might help :

https://www.youtube.com/watch?v=qJps43vWsWM&list=PLApPcvU5-R26t4dylOnPy8A2-lr4C0C--&index=5

[v-xinruzhu-msft]

Hi @asfasfgasfg 

I test your code, it works on my table

The following is my table relationship:

Can you provide some sample data or pbix file?

Or you can try to delete the measure and create it again.

Best Regards!

Yolo Zhu

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

[asfasfgasfg]

https://drive.google.com/file/d/1ggd2QiTbAslJGYKvg3WYX9oQL4ED8osx/view?usp=share_link 

Here is a link to the PBIX file

I don't have the date column in my visual.

Edit File is now free to everyone with access to the link. sorry..

[v-xinruzhu-msft · Accepted solution]

Hi @asfasfgasfg 

I make some change to your three measures:

Huidig Jaar = CALCULATE(
    sum(
        Palmo_Transactions[AmountFC]),
        filter(
          ALLSELECTED(Palmo_Transactions),[Date]<=MAX(DateTable[DAY_DATE])&&YEAR(Palmo_Transactions[Date])=[CY])
            )

Twee jaar terug = 
CALCULATE(
    sum(
        Palmo_Transactions[AmountFC]),
        filter(
          ALLSELECTED(Palmo_Transactions),[Date]<=MAX(DateTable[DAY_DATE])&&YEAR(Palmo_Transactions[Date])=[CY]-2)
            )

Vorig Jaar = CALCULATE(
    sum(
        Palmo_Transactions[AmountFC]),
        filter(
          ALLSELECTED(Palmo_Transactions),[Date]<=MAX(DateTable[DAY_DATE])&&YEAR(Palmo_Transactions[Date])=[CY]-1)
            )

Output:

Best Regards!

Yolo Zhu

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