Split column into multiple rows by position

Hi Anonymous ,

DAX can use something like the following:

Table =
VAR _G =
    GENERATESERIES( 0, 5, 1 ) // 1 column to 6 rows
VAR _A =
    ADDCOLUMNS(
        CROSSJOIN( 'sample data', _G ),
        "PDF",
            MID( [Data], 6000 * [Value] + 1, 6000 )
    )
RETURN
    GROUPBY( _A, [DocID], [PDF] )

Unfortunately, CROSSJOIN() is limited in Direct Query. If you want to know  detail about the DAX , i put the pbix file in the end you can refer.

Maybe you can use M function to connect to file dynamically via parameters which is a path list of PDFs.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters 

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.