Forum Discussion

tdailey77's avatar
tdailey77
Frequent Visitor
6 years ago
Solved

Need to be able to count blank values

Hello, I recently moved from On-Premise SQL Microsoft Dynamics to D365 online and moving my data source to the online database has been a huge headache.   I don't know why I lose my option set label...
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi tdailey77 ,

     

    Try replacing your BLANK() values with some value like - "Unknown", "Not Known", etc.

    It's always good to clean your data specially if it has missing values like blanks.

     

    Thanks,

    Pragati

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi tdailey77 ,

 

Try replacing your BLANK() values with some value like - "Unknown", "Not Known", etc.

It's always good to clean your data specially if it has missing values like blanks.

 

Thanks,

Pragati

tdailey77's avatar
tdailey77
Frequent Visitor
6 years ago

Thank you Pragati11 , that fixed it!  I forgot that I can do that in Power Bi and leave my dynamics database to have the blank values still, very appreciated!