Forum Discussion
Appended Data Showing in Query View Not In Report
Hi NMC20 - Double-check that your IF statement logic is correctly handling the conditions for both Paypal and Stripe. You may want to add a condition to handle the case where RELATED returns blank
Modified one, you can try below:
% Revenue =
VAR InstallationDate = RELATED('Sites Information'[Installation Date])
VAR ThreeMonthsDate = RELATED('Sites Information'[3 Months Date])
VAR First3MonthsPercentage = RELATED('Sites Information'[First %])
VAR After3MonthsPercentage = RELATED('Sites Information'[3 Months %])
RETURN
IF(
ISBLANK(InstallationDate) || ISBLANK(ThreeMonthsDate) || ISBLANK(First3MonthsPercentage) || ISBLANK(After3MonthsPercentage),
BLANK(), -- or a default value like 0 if needed
IF(
[Date of Order] >= InstallationDate && [Date of Order] < ThreeMonthsDate,
First3MonthsPercentage,
IF(
[Date of Order] >= ThreeMonthsDate,
After3MonthsPercentage,
BLANK()
)
)
)
Thanks for the response!
I don't think this would solve my problem because my report is entirely excluding Paypal data, even on fields which aren't blank in the query table (e.g. transaction data) so I suspect I've appended the data incorrectly or my relationships aren't right - I'm afraid I just don't understand it enough to understand what I've not done correctly.
you can try by select the All Payment Data query.Ensure all PayPal data rows are present after the append operation.If rows are missing, revisit the append settings and ensure both data sources are correctly included.
Columns from both sources must match exactly in name and data type. Mismatched column names or types can result in missing data.
Temporarily remove relationships involving All Payment Data.Create a table visual with All Payment Data fields to see if PayPal data appears. If it does, the issue is with relationships; if not, the issue is with the append process.
check these and let me know still issue exist please share pbix file by removing confidential data.
In producing a sanitised version to post on here, I've discovered the problem.
One of the steps within my "Transform Data" stage is that, based on a booking reference ID, Power BI tells me what site this transaction relates to (my [Location] field). The results from this definitely match on Paypal, Stripe and All Payment Data because both Paypal and Stripe return the correct data on a lookup to All Payment Data on [Location] field.
When I've manually typed fake locations in to the Excel document to create fake data (so no formula based on Booking ID needed) the report brings everything back so it must be something about this [Location] field which is throwing the report.
Obviously I can create a workaround of an Excel formula to work out the location prior to Power BI but I'd like to avoid this if possible. Is there an obvious reason I'm unaware of which would make the correct data show in the table stage but not pull through to the report due to this formula?
Hope that makes sense!
