topic Re: I need to create new table with total values of each category and continues date. in DAX Commands and Tips

I need to create new table with total values of each category and continues date.

huynq — Mon, 02 Nov 2020 05:39:46 GMT

Hi guys

I'm sorry if my bad English confuse you. Thank you for comming.

I need a solution or any advices on this dataset

My Input:

Date Name Value

10/29/2020 A 1

11/02/2020 A 1

11/01/2020 B 2

11/02/2020 C 1
10/29/2020 A 3

My expected:

Date Name Value

10/29/2020 A 4

10/30/2020 A 0

11/01/2020 A 0

11/02/2020 A 1

10/29/2020 B 0

10/30/2020 B 0

11/01/2020 B 1

11/02/2020 B 0

10/29/2020 C 0

10/30/2020 C 0

11/01/2020 C 0

11/02/2020 C 1

Thanks in advance

Re: I need to create new table with total values of each category and continues date.

DataInsights — Fri, 06 Nov 2020 20:49:53 GMT

huynq,

Try this calculated table. You need a Date table in your data model.

DailyValue = VAR vNames = DISTINCT ( Table4[Name] ) VAR vStartDate = MIN ( Table4[Date] ) VAR vEndDate = MAX ( Table4[Date] ) VAR vDates = CALCULATETABLE ( DISTINCT ( Dates[Date] ), Dates[Date] >= vStartDate && Dates[Date] <= vEndDate ) VAR vResult = GENERATEALL ( vNames, ADDCOLUMNS ( vDates, "Value", IF ( ISBLANK ( CALCULATE ( SUM ( Table4[Value] ) ) ), 0, CALCULATE ( SUM ( Table4[Value] ) ) ) ) ) RETURN vResult

Re: I need to create new table with total values of each category and continues date.

huynq — Fri, 13 Nov 2020 02:40:34 GMT

Many thanks to you DataInsights . It works like a charm.