Forum Discussion

sagarsahoo_123's avatar
sagarsahoo_123
Helper IV
3 years ago
Solved

Need help to write DAX code for the below Query

Hello Team, As i am new to this DAX code, i need your support to write the code for the below requirement. I have posted the sample table to make it simpler to understand. I have a table having thr...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi sagarsahoo_123 ,

     

    This issue may caused by space value and blank value. Please check your Source data in Power Query. You can use Replace Value in Power Query.

    Here is a simple example:

    As you can see in the images, the two values are different in Text data type.

    You can use Replace Value:

     

    Final output:

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi sagarsahoo_123 ,

 

This issue may caused by space value and blank value. Please check your Source data in Power Query. You can use Replace Value in Power Query.

Here is a simple example:

As you can see in the images, the two values are different in Text data type.

You can use Replace Value:

 

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • sagarsahoo_123's avatar
    sagarsahoo_123
    Helper IV
    3 years ago

    Hello Team,

    Thanks a lot for  such detailed explanation and quick support. It helped to get the desired result. Really appreciated. 

     

    Regards,

    Sagar