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.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |