Profit Loss DAX table help

+1 vote

Below shows the report I am working on. The Profit & Loss table for last month is what I am having trouble with...

This is what I am trying to produce. Any help suggesting the DAX for this would be appreciated...

Aug 6, 2019 in Power BI by John
 • 130 points • 1,343 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Power BI

0 votes
1 answer

How do I count rows in one table based on values in another table using DAX?

If the tables are related, this is ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
 • 65,890 points • 22,556 views
0 votes
1 answer

In DAX, how do I RETURN the sum of a calculated column from a DAX Table Variable (created via ADDCOLUMN)?

You can access column variables of previously ...READ MORE

answered Oct 8, 2020 in Power BI by Gitika
 • 65,890 points • 4,502 views
0 votes
0 answers

Adding weekly start date & end date to my date table based on week number?

Adding weekly start date & end date ...READ MORE

Oct 14 in Power BI by anonymous
 • 2,560 points • 43 views
0 votes
1 answer

Adding weekly start date & end date to my date table based on week number?

In order to incorporate weekly start and ...READ MORE

answered Oct 22 in Power BI by pooja
 • 1,220 points • 41 views
+1 vote
1 answer

Is there a way to convert JSON data to readable table in power bi

Follow these steps step 1 - Click on ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
 • 18,540 points • 13,949 views
0 votes
1 answer

Dax code for calculated columns

I would recommend you to adjust the ...READ MORE

answered Oct 22, 2018 in Power BI by Hannah
 • 18,540 points • 1,076 views
+3 votes
2 answers

Combine tables in Power BI

You can also achieve this using a ...READ MORE

answered Oct 5, 2018 in Power BI by lina
 • 8,220 points
edited Oct 11, 2018 by Kalgi • 2,421 views
0 votes
1 answer

Power Bi Dax Table

You need to wrap the numbers in ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
 • 52,350 points • 1,137 views
0 votes
2 answers

Power BI Dax Multiple IF AND Statements

HI I have Column Patient 12 13 14 15 18 IN Patient=12, 13 Out ...READ MORE

answered May 23, 2019 in Power BI by VNK
 • 18,892 views
0 votes
1 answer

Distinct count filtered by condition using Power BI Dax

Try this, it should work: DistinctCountActiveMonths = CALCULATE( ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
 • 52,350 points • 37,589 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.