Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
when Im Created dax new Column Like
Date= calendar(date(2013,1,1),date(2016,12,31)
im getting error like
" A table of multiple values was supplied where a single value was expected "
Solved! Go to Solution.
HI @SrinuReddy,
Calendar function can't direct use in calculate column, you need to do some summary for result table to summary result.
Sample:
Date = COUNTROWS ( CALENDAR ( DATE ( 2013, 1, 1 ), DATE ( 2016, 12, 31 ) ) ) Date = MAX ( CALENDAR ( DATE ( 2013, 1, 1 ), DATE ( 2016, 12, 31 ) ) ) Date = MIN ( CALENDAR ( DATE ( 2013, 1, 1 ), DATE ( 2016, 12, 31 ) ) )
Can you share some sample data with expected result to help us clear your requirement?
Regards,
Xiaoxin Sheng
CALENDAR returns a table so you have to use New Table instead of New Column
@Anonymous
but i want do DAX calculation On Existed Table..
HI @SrinuReddy,
Calendar function can't direct use in calculate column, you need to do some summary for result table to summary result.
Sample:
Date = COUNTROWS ( CALENDAR ( DATE ( 2013, 1, 1 ), DATE ( 2016, 12, 31 ) ) ) Date = MAX ( CALENDAR ( DATE ( 2013, 1, 1 ), DATE ( 2016, 12, 31 ) ) ) Date = MIN ( CALENDAR ( DATE ( 2013, 1, 1 ), DATE ( 2016, 12, 31 ) ) )
Can you share some sample data with expected result to help us clear your requirement?
Regards,
Xiaoxin Sheng
User | Count |
---|---|
98 | |
91 | |
84 | |
72 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |