Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Thank you so much
@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.
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!
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
@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.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |