Please i am new to dax functions. i am trying to achive the below template reports on powerbi.
I Have done calculated colums for LG,Samsung and nexus seperately. that is to say i have the sum of each product posted to my chart of accounts.
However i do not know how to return the qualitative aspect of my template, which is revenue, haulage etc for each of the product.
This is my dax;
LG = (CALCULATE(SUM('General Ledger Entries'[Amount]),FILTER('Chart of Account',' Chart of Account'[No]=5000100))
We probably need to learn a little more about your data model.
YOu say you don't know how to do Revenue for LG, but your sample set of data shows 20,000. Is this wrong?
Proud to be a Datanaut!
yes u re correct. i have done calculated colums to return the value of each of my products.
i select the matrix visual and put each calcuted column on column
However, i want the visual to appear like this;
Can you give some further details or example of your data? To help you bettwe without further information is difficult.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.