Return value of a column based on selection

Question

Hello everyone,&nbsp;I have below request where we need to do some transformation in original source data then pivot and add T/F formula.&nbsp;Is there a way in PBI that I can reach the required T/F formula and then visualise.&nbsp;&nbsp;Source- Added Col 1Source- Added Col 2Output layout with T/F FormulaThank you so much&nbsp;

pragati11 · Answer

Hi&nbsp;ritanoori&nbsp;,&nbsp;Please follow the following article on Pivot/Un-pivot in Power BI:https://databear.com/power-bi-pivot-and-unpivot-columns/&nbsp;Thanks,Pragati

amitchandak · Answer

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 · Answer

Hi amitchandak&nbsp;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 &amp; D cols.&nbsp;

v-diye-msft · Answer

Hi&nbsp;ritanoori&nbsp;
&nbsp;
You can use the IF function to achieve the requirement:
https://docs.microsoft.com/en-us/dax/if-function-dax&nbsp;
&nbsp;
Similar threads could be your reference:
https://community.powerbi.com/t5/Desktop/Multiple-IF-AND-OR-Function/m-p/1111883&nbsp;
https://community.powerbi.com/t5/Desktop/IF-function-with-multiple-conditions/m-p/204241&nbsp;
https://community.powerbi.com/t5/Desktop/Multiple-IF-statement-DAX/m-p/982633&nbsp;
&nbsp;
&nbsp;

ritanoori · Answer

v-diye-msft&nbsp;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.&nbsp;then apply if function.

Forum Discussion

Return value of a column based on selection

7 Replies

Related content

Return Column Name if Zero Value

Return Selected Value in calculated Column

Creating custom columns keeps returning a structured Table column

Create measure to return value from column when condition met for two other columns

Need column to return date in working days from today, from query table column.