Forum Discussion
Helper IIFull outer join between two datasets in Power BI Report Builder
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
4 Replies
- amitchandak
Super User
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
ParamjitIt 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.
- Paramjit
Team can we get any help on pagianted report full outer join.
