Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I am trying to add a custom column using the following DAX Code. I keep getting the error "Token Eof expected" around the first line - "....StartDate =". Please help.
VAR StartDate =
DATE(
YEAR([Completion time])
- IF(MONTH([Completion time]) < 8, 1, 0),
8,
1
)
VAR Block1End = StartDate + 9 * 7
VAR Block2End = Block1End + 10 * 7
VAR Block3End = Block2End + 9 * 7
VAR Block4End = Block3End + 10 * 7
RETURN
IF(
CONTAINSSTRING([Select your class:], "First Year"),
SWITCH(
TRUE(),
[Completion time] >= StartDate
&& [Completion time] < Block1End, "Block 1",
[Completion time] < Block2End, "Block 2",
[Completion time] < Block3End, "Block 3",
[Completion time] < Block4End, "Block 4",
BLANK()
),
SWITCH(
TRUE(),
[Completion time] >= StartDate
&& [Completion time] < Block1End, "Block 5",
[Completion time] < Block2End, "Block 6",
[Completion time] < Block3End, "Block 7",
[Completion time] < Block4End, "Block 8",
BLANK()
)
)
Solved! Go to Solution.
hello @aman_sinha
do you mean "custom column" in Power Query?
if yes, then you will most likely get error since Power Query accepts M and doesnt accept DAX.
Hope this will help.
Thank you.
hello @aman_sinha
do you mean "custom column" in Power Query?
if yes, then you will most likely get error since Power Query accepts M and doesnt accept DAX.
Hope this will help.
Thank you.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
76 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
64 | |
59 | |
56 |