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.
Hi Team,
We have a requirement to create Full outer join between two datasets in Power BI Report Builder.
( We need the full outer join to compare the data from two different databases.)
As per checking , LOOKUP function works for only inner or left joins.
Please help.
Thank you,
Paramjit
Team can we get any help on pagianted report full outer join.
@Paramjit , if dimension values are missing power bi shows that fact value with null dimension value.
Use a measure with +0 it should do both left and right
It is for Paginated report. I have two datasets and need to join both the datasets.
There is a lookup function but it is not fullfilling the requirement. as it does not work for Full outer.
Is it possible to create full outer in Pagianted report.
It is for Paginated report. I have two datasets and need to join both the datasets.
There is a lookup function but it is not fullfilling the requirement. as looks like does not work for Full outer.
Is it possible to create full outer in Pagianted report.
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |