Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |