Forum Discussion

DonPepe's avatar
DonPepe
Icon for Helper II rankHelper II
5 years ago
Solved

Clean up M code

Hello,    I would like to know if you have another mean (more clean) to get the same result. And if not, how can I modify my code to be more understanble ?    The purpose of the code is to filter...
Show and Tell
  • wdx223_Daniel's avatar
    wdx223_Daniel
    5 years ago
    let
    Source = Excel.Workbook(File.Contents("C:\Users\TabData.xlsx"), null, true),
    Tableau1_Table = Table.TransformColumnTypes(Source{[Item="Tableau1",Kind="Table"]}[Data],{{"PLAATY Start Date", type date}}),
    DateMax = List.Max(Tableau1_Table[PLAATY Start Date]),
    DateL = Date.AddDays(Date.AddWeeks(Date.StartOfWeek(DateMax),-1),-1),
    DateM = Date.AddDays(Date.AddWeeks(Date.StartOfWeek(DateMax),-1),+5),
    Custom1 = Table.SelectRows(Tableau1_Table,each [PLAATY Start Date] >=DateL and [PLAATY Start Date] <= DateM))
in
    Custom1
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago
let
    Source = Excel.Workbook(File.Contents("C:\Users\TabData.xlsx"), null, true),
    Tableau1_Table = Table.TransformColumnTypes(Source{[Item="Tableau1",Kind="Table"]}[Data],{{"PLAATY Start Date", type date}}),
    DateMax = List.Max(Tableau1_Table[PLAATY Start Date]),
    DateL = Date.AddDays(Date.AddWeeks(Date.StartOfWeek(DateMax),-1),-1),
    DateM = Date.AddDays(Date.AddWeeks(Date.StartOfWeek(DateMax),-1),+5),
    Custom1 = Table.SelectRows(Tableau1_Table,each [PLAATY Start Date] >=DateL and [PLAATY Start Date] <= DateM))
in
    Custom1
DonPepe's avatar
DonPepe
Icon for Helper II rankHelper II
5 years ago

Wow, thanks a lot, I will learn from that.