date - A table of multiple values was supplied where a single value was expected YTD

I am trying to calculate a table where I can see the YTD values with this DAX:

Is YTD = 
IF (
    'Append'[Attribute - Date] >= DATE ( YEAR ( DISTINCT ( 'Append'[Date Ref.EoMonth] ) ), 1, 1 )
        && 'Append'[Attribute - Date] <= DISTINCT ( 'Append'[Date Ref.EoMonth] ),
    "YTD",
    "Other"
)

But I get A table of multiple values was supplied where a single value was expected

I am trying to calculate a table where I can see the YTD values with this DAX:

Is YTD = 
IF (
    'Append'[Attribute - Date] >= DATE ( YEAR ( DISTINCT ( 'Append'[Date Ref.EoMonth] ) ), 1, 1 )
        && 'Append'[Attribute - Date] <= DISTINCT ( 'Append'[Date Ref.EoMonth] ),
    "YTD",
    "Other"
)

But I get A table of multiple values was supplied where a single value was expected

Share Improve this question edited Nov 20, 2024 at 14:37 Amira Bedhiafi 1 asked Nov 20, 2024 at 10:35 Yolanda CB 156 bronze badges

Add a comment |

1 Answer 1

Sorted by: Reset to default 0

In your case DISTINCT returns a table of values but DAX expects a single value for comparison in your IF statement. Try to use MAX or MIN to get a single value returned from 'Append'[Date Ref.EoMonth] which DAX can use for comparison :

Is YTD = 
IF (
    'Append'[Attribute - Date] >= DATE ( YEAR ( MAX ( 'Append'[Date Ref.EoMonth] ) ), 1, 1 )
        && 'Append'[Attribute - Date] <= MAX ( 'Append'[Date Ref.EoMonth] ),
    "YTD",
    "Other"
)

科技改变生活-雨落星辰 - 所有的伟大,都源于一个勇敢的开始

date - A table of multiple values was supplied where a single value was expected YTD - Stack Overflow

1 Answer 1

与本文相关的文章

评论列表(0)