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,
I am trying (struggling actually ...) to join two tables - Item Cost and Invoice, to get the Item Cost, per invoice.
Item Cost Table can hold different cost for different date periods for the same Item. And invoice table contains the Invoice ad Item info.
In SQL, I can join like :
select
INV.Invoicenumber,
INV.ITEMID,
IC.Cost
FROM
InvoiceTable INV
outer left join Itemcost IC
on INV.Itemid = IC.Itemid
where
INV.Invoicedate >= IC.ItemCostStartDate
AND INV.Invoicedate < IC.ItemCostEndDate
is there any way, I can replicate this in Power BI way ? I.e. Merge queries or DAX ?
Thanks for your help.
Solved! Go to Solution.
@PattemManohar : I think this will fix my issue but I'm not able to test it becase I'm getting the below error (the tables are really huge):
"There's not enough memory to complete this operation. Please try again later when there may be more memory available."
I will re-try and let you know my feedback.
Thanks again !
@yuvara It will be really helpful if you always provide sample test data and expected output, to suggest an accurate solution.
Anyway, here is the similar post that you are looking for.
Proud to be a PBI Community Champion
@PattemManohar : I think this will fix my issue but I'm not able to test it becase I'm getting the below error (the tables are really huge):
"There's not enough memory to complete this operation. Please try again later when there may be more memory available."
I will re-try and let you know my feedback.
Thanks again !
Thanks ! It works !!
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |