Forum Discussion
#Need DAX Formula#
Hi All,
I need dax formula for some criteria which is explain below:
I have three table and i want unit cost from the next two table.
steps are below:
1. first of all, need to collect data from tblcostvalue with filtering item no and date (date can be <=date)
2. after that sum all values from tblcostvalue on item no with specific date:
such as : value=cost actual+cost expected
3.
then sum all values from tblItemQuantity on item no with specific date:
such as : totalQty=sum(Quantity)
4. averagecost=value/totalQty
5. insert averagecost into tblReason unit cost, by filtering date and item no.
Waiting for good feedback from comunity members.
1 Reply
Anonymous Can you post the data as text? Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
