topic Create Calculated Table in DAX Commands and Tips

Create Calculated Table

bob57 — Tue, 14 Jan 2020 06:29:56 GMT

Source data table:

Rows 2 and 4 indicate multiple payments. B Corp to be paid $150 on 1/10, 2/10, and 3/10. D Corp to be paid $200 on 1/18 and 2/18. I'm looking for a DAX formula to produce the following calculated table from the source table above:

Thank you for your time and assistance.

Re: Create Calculated Table

Mariusz — Tue, 14 Jan 2020 09:50:30 GMT

Hi bob57

You can create a table like below.

Table 2 = SELECTCOLUMNS( GENERATE( 'Table', VAR __pumnts = 'Table'[No Pymnts] RETURN GENERATESERIES( 1, __pumnts, 1 ) ), "Date", VAR __value = [Value] -1 VAR __date = 'Table'[Date] VAR __year = YEAR( __date ) VAR __month = MONTH( __date ) + __value VAR __day = DAY( __date ) RETURN DATE( __year, __month, __day ), "Payment", 'Table'[Payment], "Vendor", 'Table'[Vendor] )

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Re: Create Calculated Table

bob57 — Tue, 14 Jan 2020 14:27:24 GMT

Worked perfectly! Thank you. Now Ineed to learn how it works. Appreciate your effort.