Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
Help me out with the below dax query issue
I have a code
EVALUATE
VAR __SelectedValue = 509
VAR PayItemProjects =
FILTER(
ADDCOLUMNS(
SUMMARIZE(
PayItem,
PayItem[PayItemId],
PayItem[PayItemNumber],
PayItem[Description],
PayItem[UnitofMeasureName],
PayItem[ForecastTakeOffQuantity],
PayItem[ForecastUnitRevenue],
PayItem[Project_id],
"SumForecastFinalRevenue", SUM(PayItem[ForecastFinalRevenue])
),
"ProjectName", LOOKUPVALUE(Projects[ProjectName], Projects[Project_id], PayItem[Project_id])
),
PayItem[PayItemId] = 509)
// RETURN PayItemProjects
VAR BilledPayItem =
FILTER(
SELECTCOLUMNS(
SUMMARIZE(
BilledRevenueDetail,
BilledRevenueDetail[PayItemId],
BilledRevenueDetail[BilledDate],
"SumBilledRevenue", SUM(BilledRevenueDetail[BilledRevenue]),
"BilledQuantity", SUM(BilledRevenueDetail[BilledQuantity])
),
"PayItem[PayItemId]",LOOKUPVALUE(PayItem[PayItemId], PayItem[PayItemId], BilledRevenueDetail[PayItemId]),
BilledRevenueDetail[BilledDate],
[SumBilledRevenue],
[BilledQuantity]
)
, PayItem[PayItemId] = 509)
VAR Result =
NATURALLEFTOUTERJOIN(
PayItemProjects,
BilledPayItem
)
Return Result
But getting error
I have check the data types they are whole number. But still unable to solve.
When doing join in Data Model , all my output looks good.
Here is the result in Power Bi table view
Solved! Go to Solution.
HI, @ashmitp869
In Naturalleftouterjoin Columns being joined must have the same data type and the same name in both tables.
here you take 9 column in Payitemprojects and 4 column from Billedpayitem.
Take same numbers of column from both tables with same name and same data type.
Refer Link for more information.
Best Regards
Dangar.
HI, @ashmitp869
In Naturalleftouterjoin Columns being joined must have the same data type and the same name in both tables.
here you take 9 column in Payitemprojects and 4 column from Billedpayitem.
Take same numbers of column from both tables with same name and same data type.
Refer Link for more information.
Best Regards
Dangar.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |