topic Compare measure in DAX Commands and Tips

Compare measure

ziomalski — Wed, 26 Apr 2023 08:22:03 GMT

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 reservations were made since last file.

I want to compare every time how many reservations were made from the date of generated file. I can make measure "last 7 days" but when i want to see it next days 7 days will be count from today.

file 1 is generated on 1.4.2023 and has 10 rows

file 2 is generated on 8.04.2023 and has 20 rows

Files are written into speficic folder, then the folder goes to the Power Query. I thought the generated day of the file could be helpful but i can't solve this. thank you for your answers how could it be solved?

Re: Compare measure

tamerj1 — Wed, 26 Apr 2023 09:05:30 GMT

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.

Re: Compare measure

wdx223_Daniel — Thu, 27 Apr 2023 01:43:45 GMT

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])))

Custom1