Forum Discussion

Urielpc's avatar
Urielpc
Frequent Visitor
4 years ago
Solved

Create table with dummy transaction

hello, i have to create new table with dummy transaction base on  CustomerCreatedDate Sample: CustomerName , CreateDate  John a                , 01/08/2021   I need to create a new table with ...
  • smpa01's avatar
    smpa01
    4 years ago

    Urielpc  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

     

     

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

Urielpc  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

 

 

  • Urielpc's avatar
    Urielpc
    Frequent Visitor
    4 years ago

    Thanks very much, smpa01 

    PREVIEW