Data Manipulation with powerBI Dax

0 votes

I want to make some data manipulation with Dax. Here's what I need:

  1. Number of lines for each month in ' First Date' & number of lines for each month in 'Last Date'

  2. Filtered by category and country.

  3. Make a graph like the one on the screen.

Here's the Data and the graph I want.

Thank you in advance,

enter image description here

enter image description here

Mar 10 in Power BI by Edureka
• 9,320 points
48 views

1 answer to this question.

0 votes

SELECTCOLUMNS is a function that adds computed columns to a table or a table expression.
SUBSTITUTEWITHINDEX returns a table that depicts a left semijoin of the two input tables.
SUMMARIZE generates a summary table for the totals requested over a collection of groups.

SUMMARIZECOLUMNS creates a summary table for a bunch of data.

Returns a table with one or more columns by using the Table Constructor.

TOPN returns the supplied table's top N rows.

TREATAS filters columns from an unrelated table using the result of a table expression.

UNION From two tables, it creates a union (join) table.

VALUES returns a single-column table containing the unique values from the supplied table or column.

ROLLUP modifies SUMMARIZE's behaviour by adding rollup rows to the result on the columns specified by the groupBy columnName argument.
ROLLUPADDISSUBTOTAL modifies the behaviour of SUMMARIZECOLUMNS by adding rollup/subtotal rows based on the groupBy columnName columns to the result.
Within an ADDMISSINGITEMS statement, ROLLUPISSUBTOTAL pairs rollup groups with the column added by ROLLUPADDISSUBTOTAL.
ROLLUPGROUP modifies SUMMARIZE and SUMMARIZECOLUMNS behaviour by adding rollup rows to the result on columns given by the groupBy columnName argument.
ROW returns a table with a single row containing the values that each column's expressions produce.

answered Mar 14 by Edureka
• 8,820 points

Related Questions In Power BI

0 votes
1 answer

How to connect to data with PowerBI desktop?

With Power BI Desktop, you can connect ...READ MORE

answered Oct 27, 2020 in Power BI by Rajiv
• 8,910 points
113 views
0 votes
1 answer

Integrate Google Analytics data with Power BI data

When you use standard google analytics connector ...READ MORE

answered Oct 3, 2018 in Power BI by Kalgi
• 52,350 points
320 views
0 votes
1 answer

What options do I have for viewing and working with data on premises

There are three ways to achieve the ...READ MORE

answered Oct 15, 2018 in Power BI by Hannah
• 18,570 points
195 views
+1 vote
1 answer

Have column with multiple values in powerBI, for use with a slicer in power bi

It can be achieved depending on the result you ...READ MORE

answered Oct 22, 2018 in Power BI by Hannah
• 18,570 points
5,904 views
0 votes
1 answer

list reports with calculated percentage in Power BI using dax

Create a Measure called Total Revenue: Total Revenue = SUMX( ...READ MORE

answered Oct 22, 2018 in Power BI by Hannah
• 18,570 points
743 views
0 votes
1 answer

Power Query : http POST request with form data

Try using Uri.BuildQueryString and Json.Document. let ...READ MORE

answered Dec 12, 2018 in Power BI by Upasana
• 8,620 points
6,870 views
0 votes
1 answer

Power Query : making HTTP POST request with form data

Try Using Uri.BuildQueryString and Json.Document let ...READ MORE

answered Feb 14, 2019 in Power BI by Upasana
• 8,620 points
4,165 views
0 votes
0 answers
0 votes
1 answer

PowerBI Data Model and Slicers for Many-to-Many-to-Many too Many Over Time

A relationship with a many-many cardinality in Power BI ...READ MORE

answered Mar 2 in Power BI by Edureka
• 8,820 points
64 views
0 votes
1 answer

Spell check in PowerBI

Use this API service and create a ...READ MORE

answered Mar 2 in Power BI by Edureka
• 8,820 points
31 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP