Calculated Column

[Mark_Hankinson]

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

[rafaelmpsantos]

Can you show a sample of this data?

[Mark_Hankinson]

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

[v-yuezhe-msft · Accepted solution]

@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

[Mark_Hankinson]

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

Regards

Mark