Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
User | Count |
---|---|
131 | |
74 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
62 | |
54 |