How to do it...

To implement this recipe, perform the following steps:

1. Use File and then Save As to save Chapter13R10Step1.pbix as Chapter13R10Step2.pbix.
2. Create the following table:

R10_Table = 
    VAR __Table = 
        ADDCOLUMNS(
            GENERATESERIES(1,1000000,1),
            "TimeStamp",NOW()+[Value]/24/60/60
        )
RETURN
    SELECTCOLUMNS(__Table,"TimeStamp",[TimeStamp])

3. Save the file using File and then Save.
4. Observe that the file size of Chapter13R10Step2.pbix is 11,912 KB.
5. Use File and then Save As to save Chapter13R10Step2.pbix as Chapter13R10Step3.pbix.
6. Create the following table:

R10_Table2 = 
    VAR __Table = 
        ADDCOLUMNS(
            ADDCOLUMNS(
                GENERATESERIES(1,1000000,1),
                "TimeStamp",NOW()+[Value]/24/60/60
            ),
            "Date",DATE(YEAR([TimeStamp]),MONTH([TimeStamp]),DAY([TimeStamp])),
            "Hour",HOUR([TimeStamp]),
            "Minute",MINUTE([TimeStamp]),
            "Second",SECOND([TimeStamp])
        )
RETURN
    SELECTCOLUMNS(
        __Table,
        "Date",[Date],
        "Hour",[Hour],
        "Minute",[Minute],
        "Second",[Second]
    )

7. Delete the R10_Table table.
8. Save the file using File and then Save.
9. Observe that the file size of Chapter13R10Step3.pbix is 51 KB.