Forum Discussion

AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

PQ Multiple IF

Hi good day can anyone help me on my PQ. i have 3 column on my table Hrs, Type No and Mat%.  - 1st condition -  IF the column Type No is equal to MN then on the result will be the Hrs  - 2nd condit...
Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    Thankyou, Cookistador, for your response.

    Hi AllanBerces,

    We appreciate your inquiry on the Microsoft Fabric Community Forum.

    Based on my understanding of the issue, please find attached a screenshot and a sample PBIX file that may help resolve the problem:


    We hope the information provided is helpful. If you have any further questions, please feel free to contact the Microsoft Fabric community.

    Thank you.




AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
1 year ago

Hi Cookistador thank you for the reply but it not giving the rigth value especially to 2nd condition, it show 0 to all MN should be the value of hrs column

Cookistador's avatar
Cookistador
Icon for Super User rankSuper User
1 year ago

I made a test, with the dataset you shared, and I got the following result (I just lost the decimal when I pasted it)

 

Can you show me the result of your column? Did you just copy and paste the code I provided ?