Skip to main content
cancel
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
kruthikav
Frequent Visitor

Error while replacing blank with "N/A" in a measure which is in decimal format.

I have a measure in Decimal format and I want to replace blank values with "N/A". But getting below error. How to solve this?

kruthikav_0-1671446185975.png

 

1 ACCEPTED SOLUTION
Mahesh0016
Super User
Super User

CW DOS =
 VAR Cal = [WOS]*7

 RETURN
 IF(Cal=BLANK(),"N/A",Cal)
 
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! 

View solution in original post

4 REPLIES 4
Idrissshatila
Super User
Super User

Hello,

 

 Try to make the second condition like this : format( ( [wos*7]),"#")

If I answered your question, please mark my post as solution, Appreciate your Kudos!

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Mahesh0016
Super User
Super User

CW DOS =
 VAR Cal = [WOS]*7

 RETURN
 IF(Cal=BLANK(),"N/A",Cal)
 
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! 

Still getting same error. Cannot convert value 'N/A' of type text to type number.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.