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, 2022 in Power BI by Edureka
• 13,670 points
877 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.

Preparing for the Power BI exam? Check out Power BI Course Content now! 

answered Mar 14, 2022 by gaurav
• 23,260 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
461 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,360 points
601 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
439 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
6,933 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
1,334 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
8,276 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
5,615 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, 2022 in Power BI by gaurav
• 23,260 points
1,661 views
0 votes
1 answer

How to load large images in PowerBi

To get around this, separate the image's ...READ MORE

answered Mar 2, 2022 in Power BI by gaurav
• 23,260 points
888 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