March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi,
Can you help in solving this error? Not sure how to solve this. Also need to verify the EOM column.
DateTable =
Solved! Go to Solution.
EOM looks fine.
You can't have a variable with the same name as a table or else it's ambiguous which one you're referring to. As Greg points out, it's common practice to use prefix variable names with underscores to prevent conflicts with table and reserved words. Like this:
DateTable =
VAR __Startate = MIN ( Customer_Data[BILL DATE] )
VAR __EndDate = MAX ( Customer_Data[BILL DATE] )
VAR __DateTable =
ADDCOLUMNS (
CALENDAR ( __Startate, __EndDate ),
"Year", YEAR ( [Date] ),
"Quarter Name", FORMAT ( [Date], "\QQ" ),
"Quarter Number", QUARTER ( [Date] ),
"Month Name", FORMAT ( [Date], "MMM" ),
"Month Number", MONTH ( [Date] ),
"Month Year", FORMAT ( [Date], "MM YYYY" ),
"Month Year Sort", VALUE ( FORMAT ( [Date], "YYYYMM" ) ),
"End Of Month", EOMONTH ( [Date], 0 )
)
RETURN
__DateTable
(Extra comma before the final ) removed.)
EOM looks fine.
You can't have a variable with the same name as a table or else it's ambiguous which one you're referring to. As Greg points out, it's common practice to use prefix variable names with underscores to prevent conflicts with table and reserved words. Like this:
DateTable =
VAR __Startate = MIN ( Customer_Data[BILL DATE] )
VAR __EndDate = MAX ( Customer_Data[BILL DATE] )
VAR __DateTable =
ADDCOLUMNS (
CALENDAR ( __Startate, __EndDate ),
"Year", YEAR ( [Date] ),
"Quarter Name", FORMAT ( [Date], "\QQ" ),
"Quarter Number", QUARTER ( [Date] ),
"Month Name", FORMAT ( [Date], "MMM" ),
"Month Number", MONTH ( [Date] ),
"Month Year", FORMAT ( [Date], "MM YYYY" ),
"Month Year Sort", VALUE ( FORMAT ( [Date], "YYYYMM" ) ),
"End Of Month", EOMONTH ( [Date], 0 )
)
RETURN
__DateTable
(Extra comma before the final ) removed.)
@AmeenVanakar Put one or two underscore characters prior to your variable names and you will avoid these kinds of things.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
94 | |
86 | |
84 | |
76 | |
49 |
User | Count |
---|---|
160 | |
144 | |
103 | |
74 | |
57 |