Table summarize

[Anonymous]

Dear Sir

Good Morning

i have a table with 4 columns as shown below:

 

 

how can i convert(summarize) to below format by DAX:

Thanks

Jyaul

 

[tackytechtom]

Hi @Anonymous ,

Totally agree on @TomMartens post.

Calculation groups might also help you with this. Here is a small overview of what you can do with them:

Top 10 uses for Calculation Groups — Apex Insights: Power BI tips & tricks

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[TomMartens · Accepted solution]

Hey @Anonymous ,

your question covers many areas inside Power BI, ranging from data modeling, to DAX calculation.

For this reason, consider creating an Excel file that contains the sample data from the screen shot. Upload the file to onedrive or dropbox and share the link!

Data Modeling, here you will find an introduction into data modeling with Power BI:https://docs.microsoft.com/en-us/learn/paths/model-power-bi/?WT.mc_id=DP-MVP-5003068

I suggest creating

a dimension table containing the document IDs (from my understanding this is only the numeric part) and

a fact table, containing the document ID as key column and the submitted date column and the return date column.

You have to use a date table (the calendar table), almost everything about time intelligence can be found here: Time patterns – DAX Patterns

As there are two date columns in your fact table you will realize that only one relationship can be active, for this reason, read the following article: Welcome to Power BI theatre: Role-Playing Dimensions! - Data Mozart (data-mozart.com)

Hopefully, this provides the information you need to tackle your challenge.

Regards,
Tom