Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

i am doing a custom column creation but there is an error message

‎05-16-2022 05:01 AM

susanpalliparam_0-1652702313702.png

i am trying to a custom column but facing this issue could i get an assist 

@amitchandak 

Labels:
Message 1 of 3
201 Views
0
1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

‎05-19-2022 12:24 AM

Hi @Anonymous ,

You enter more "[" then you need.

Number.ToText(Date.Year([[Year_start_date]))&"P"&Number.ToText([[period_number])

vluwangmsft_0-1652944943530.png

Change to :

Number.ToText(Date.Year([Year_start_date]))&"P"&Number.ToText([period_number])

vluwangmsft_1-1652945002001.png

 

You picture provided:

vluwangmsft_3-1652945083674.png

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

View solution in original post

Message 3 of 3
135 Views
0
2 REPLIES 2
v-luwang-msft
Community Support
Community Support

‎05-19-2022 12:24 AM

Hi @Anonymous ,

You enter more "[" then you need.

Number.ToText(Date.Year([[Year_start_date]))&"P"&Number.ToText([[period_number])

vluwangmsft_0-1652944943530.png

Change to :

Number.ToText(Date.Year([Year_start_date]))&"P"&Number.ToText([period_number])

vluwangmsft_1-1652945002001.png

 

You picture provided:

vluwangmsft_3-1652945083674.png

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

Message 3 of 3
136 Views
0
Anonymous
Not applicable

‎05-16-2022 05:02 AM

susanpalliparam_0-1652702570011.png

 

Message 2 of 3
198 Views
0

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All