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,355 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,770 points • 22,637 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,770 points • 4,543 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
 • 5,530 points • 62 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
 • 4,690 points • 79 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,520 points • 13,994 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,520 points • 1,120 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,464 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,157 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,936 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,640 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.