Tutorial by Examples

let Source = Folder.Files("\\jsds1.live\dfs\Userprofiles\ixh500\UPM_Profile\desktop\PQ Desktop Demos\Set 2"), #"Lowercased Text" = Table.TransformColumns(Source,{{"Extension", Text.Lower}}), #"Filtered Rows" = Table.SelectRows(#"Lowercased ...

Previous Quarter Sales:=CALCULATE(FactSales[Sales], PREVIOUSQUARTER(DimDate[DateKey])) (Calculates the total sales for the previous quarter, based on the Sales column in the FactSales table and the DateKey in the DimDate table, depending on the filters applied in a PivotTable or PivotChart)