Return value of a column based on selection

[ritanoori]

Hello everyone, 

I have below request where we need to do some transformation in original source data then pivot and add T/F formula. 

Is there a way in PBI that I can reach the required T/F formula and then visualise. 

Source- Added Col 1Source- Added Col 2Output layout with T/F Formula

Thank you so much 

[ritanoori]

@v-diye-msft Thanks. This will be the last step to use if. What I want to acheive first is to pivot by company, location and curr the compare each company, location base and trans cur. 

then apply if function.

[v-diye-msft]

Hi @ritanoori 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!

[ritanoori]

Hi @v-diye-msft No, I wasn't able to find a solution yet. 

[v-diye-msft]

Hi @ritanoori 

You can use the IF function to achieve the requirement:

https://docs.microsoft.com/en-us/dax/if-function-dax 

Similar threads could be your reference:

https://community.powerbi.com/t5/Desktop/Multiple-IF-AND-OR-Function/m-p/1111883 

https://community.powerbi.com/t5/Desktop/IF-function-with-multiple-conditions/m-p/204241 

https://community.powerbi.com/t5/Desktop/Multiple-IF-statement-DAX/m-p/982633 

[amitchandak]

@ritanoori , We are not able to see any C or D column, Do it is difficult to make sense.

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

[ritanoori]

Hi @amitchandak 

thanks for reply. My bad I tried to upload the excel but couldn't and I forgot to change the picture comment. I uploaded a new picture which has the details for C & D cols. 

[Pragati11]

Hi @ritanoori ,

Please follow the following article on Pivot/Un-pivot in Power BI:

https://databear.com/power-bi-pivot-and-unpivot-columns/

Thanks,

Pragati