cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mark_Hankinson Frequent Visitor
Frequent Visitor

Calculated Column

Hi

 

This is my first post (and probably the first of quite a few).  My company is implementing Power BI and I am writing some reports but have hit a stumbling block.

 

I have linked to an SQL table (Value Ledger Entries Table from Navision 2009) and am in Query Editor in PowerBI.  I will give some background to the issue and hopefully you good people can help.

 

My table is sales data, but due to how we accrue for some customer rebates there is a column called "Cost Non-Invtbl".  This only has data in it when the column "Source Code" equals "PURCHASES".  When "Source Code" has "SALES" in it I can get all the data I need apart from the rebates.  The link from "Source Code" "PURCHASES" to "Source Code" "SALES" is via another column called "Item Ledger Entry No.".  However, I do not know the DAX formula to put in to get the "Cost Non-Invtbl" against "Source Code" "SALES".

 

The reason I need it is because the "PURCHASES" data does not have any of the  customer analysis attached.

 

I hope all that makes sense.  I am more than happy to provide some sample data if needed.

 

If I did this in Excel my formula would be =SUMIFS(Cost Non-Invtbl, Source Code, "PURCHASES", Item Ledger Entry No., Item Ledger Entry No. of the row)

 

Many thanks

Mark

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Calculated Column

@Mark_Hankinson,

You can get started from the following official article.
https://docs.microsoft.com/en-us/power-bi/desktop-quickstart-learn-dax-basics

And you can check out DAX Resource Center Wiki to get multiple resources shared by BI community members.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Highlighted
rafaelmpsantos Established Member
Established Member

Re: Calculated Column

Can you show a sample of this data?

Mark_Hankinson Frequent Visitor
Frequent Visitor

Re: Calculated Column

Hi rafaelmpsantos 

Thankyou for posting and sorry for the delay in replying but I have been in meetings all day.

 

I have realised that I was missing an important column "Applied source No."  This column is doing what I want to achieve - as such I do not require any further help on this query but will probably post on others.  That said, is there an online resourse that anyone can suggest to learn/understand DAX?

 

Thanks & Regards

Mark

 

 

Moderator v-yuezhe-msft
Moderator

Re: Calculated Column

@Mark_Hankinson,

You can get started from the following official article.
https://docs.microsoft.com/en-us/power-bi/desktop-quickstart-learn-dax-basics

And you can check out DAX Resource Center Wiki to get multiple resources shared by BI community members.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Mark_Hankinson Frequent Visitor
Frequent Visitor

Re: Calculated Column

Many thanks.  I will do some reading over the weekend.

 

Regards

Mark