Create table with dummy transaction

Question

hello,i have to create new table with dummy transaction base on&nbsp;CustomerCreatedDateSample:CustomerName , CreateDate&nbsp;John a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; , 01/08/2021&nbsp;I need to create a new table with one row per month till current monthJohn a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; , 01/08/2021John a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; , 01/09/2021John a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; , 01/10/2021John a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; , 01/11/2021John a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; , 01/12/2021&nbsp;How can i do this with Dax or M querythanks

smpa01 · Accepted Answer

Urielpc&nbsp; pbix is attached; the DAX uqery is following
Table 2 =
VAR _1 =
    ADDCOLUMNS (
        'Table',
        "lastDate", DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 )
    )
VAR _2 =
    FILTER (
        GENERATE (
            _1,
            DATESBETWEEN ( 'Calendar'[Date], 'Table'[CreatedDate], [lastDate] )
        ),
        DAY ( [Date] ) = 1
    )
RETURN
    _2

&nbsp;
&nbsp;

Forum Discussion

Create table with dummy transaction

2 Replies

Related content

Create new table

Lakehouse Table Generate Create Table

Create rows from 2 tables

Creating Date Tables

Most Recent Transaction