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.
Hey all,
I'm traying to create a function in a new query.
Could you please let me know what is wrong ?
I'm getting the following error : "Token Literal expected."
= (DateValue as date, MonthEnding as number) =>
let
CheckYear = Date.Year ( DateValue ) > Date.Year ( DateTime.LocalNow() ),
CheckMonth = Date.Year ( DateValue ) = Date.Year ( DateTime.LocalNow() ) and Date.Month ( DateValue ) > MonthEnding,
FiscalYear2 =
if
CheckYear
then
"NY"
else
if
CheckMonth
then
"NY"
else
"CY"
in
FiscalYear2
Solved! Go to Solution.
HI @Anonymous,
You can try to use following M query code if it suitable for your requirement:
(DateValue as date, MonthEnding as number) as text=>
let
CheckYear = Date.Year ( DateValue ) > Date.Year ( DateTime.LocalNow() ),
CheckMonth = Date.Year ( DateValue ) = Date.Year ( DateTime.LocalNow() ) and Date.Month ( DateValue ) > MonthEnding,
FiscalYear2 =
if
CheckYear
then
"NY"
else if
CheckMonth
then
"NY"
else
"CY"
in
FiscalYear2
Regards,
Xiaoxin Sheng
HI @Anonymous,
You can try to use following M query code if it suitable for your requirement:
(DateValue as date, MonthEnding as number) as text=>
let
CheckYear = Date.Year ( DateValue ) > Date.Year ( DateTime.LocalNow() ),
CheckMonth = Date.Year ( DateValue ) = Date.Year ( DateTime.LocalNow() ) and Date.Month ( DateValue ) > MonthEnding,
FiscalYear2 =
if
CheckYear
then
"NY"
else if
CheckMonth
then
"NY"
else
"CY"
in
FiscalYear2
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |