Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
117 | |
109 | |
107 | |
92 | |
68 |
User | Count |
---|---|
167 | |
130 | |
129 | |
95 | |
91 |