Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

YTD Calculation Not working in Power BI Direct Query

I have created a measure for YTD calculation but it returns no results, not sure what I am doing wrong
 
YTD SALES = CALCULATE (
SUM('Group Results'[FC_OCC8_CLAIMS]),
FILTER (
ALL ( 'CalendarGroup' ),
CalendarGroup[Day Date] <= MAX ( CalendarGroup[Day Date] )
&& YEAR ( CalendarGroup[Day Date] ) = YEAR ( MAX ( CalendarGroup[Day Date] ) )
)
)
 
 
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    What is the other relationship connected to Group Results. That formula looks like it should work.

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Anonymous ,

     

    Could you please share some sample data and clarify more details about your requirement?

     

    Regards,

    Jimmy Tao