Forum Discussion

ziomalski's avatar
ziomalski
New Member
3 years ago

Compare measure

Hi, how to solve the problem. Reservations for the defined period are inflowing into the table (incrementially). I'm generating every week a file with fullfiled reservations. I want to see how many...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi ziomalski 
I'm not sure if there is a way to get Power Query to display attribute columns for folders. As far as I know it shows only the attributes of files. Perhaps wdx223_Daniel has a better answer to this query.

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Thanks tamerj1 

    ziomalski if you want get the file's generated date, you can bring in the filed value of "Date created" by the function of Folder.Files.

    let

        Source=Folder.Files("your folder path"),

        Coustom1=Table.Combine(Table.TransformRows(Source,each Table.AddColumn(Excel.Workbook([Content])[Data]{0},"Generated Date",(x)=>[Date created])))

    in

       Custom1