Forum Discussion
Helper Iplease provide solution for below error
Hi ashshiv_123 ,
Your mistake was caused by an error in your formulas:
The first screenshot:
1. Month[ ] function is wrong, Month() is correct
MONTH(<datetime>) 2. Don't nest formulas too much, try use VAR variables
3. If there is more than one condition, try using the switch function
The second screenshot
The format function must have at least two parameters
FORMAT(<value>, <format_string>[, <locale_name>])
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IOk. Thanks for providing solution to my issue.
Will try it and will let you know.
Regarding using VAR variables, thanks for guiding me. but i am still in begginers phase of self learning power BI. i have yet to reach that phase. will definitly apply your suggestion once i reach that stage. i am still doing R & D. many more to learn yet.
Once again thanks for your feedback.
Thanks & Regards,
ashshiv_123