Forum Discussion

Rachel_123's avatar
Rachel_123
Icon for Helper I rankHelper I
3 years ago
Solved

Please help converting DAX to M

Hi, I've been struggling with a problem for awhile and finally found a workaround but to implement the solution I need to create a table in Power query in M, can anyone help me please translate the f...
Need Help
  • Rachel_123's avatar
    Rachel_123
    3 years ago

    somebody gave me a script that worked

    let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"Project", "Expense Type", "Date"}, {
    {"Actuals", each List.Sum(Table.SelectRows(_, each [Versions] = "Actuals")[Value])},
    {"Current Budget", each List.Sum(Table.SelectRows(_, each [Versions] = "Current Budget")[Value])},
    {"Current Forecast", each List.Sum(Table.SelectRows(_, each [Versions] = "Current Fcst")[Value])}
    })
in #"Grouped Rows"


     

JoZu's avatar
JoZu
Frequent Visitor
3 years ago

Could you please provide some sample data with expected results. I think it would make it easier to find a working solution.

Best regards

Rachel_123's avatar
Rachel_123
Icon for Helper I rankHelper I
3 years ago

somebody gave me a script that worked

let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"Project", "Expense Type", "Date"}, {
    {"Actuals", each List.Sum(Table.SelectRows(_, each [Versions] = "Actuals")[Value])},
    {"Current Budget", each List.Sum(Table.SelectRows(_, each [Versions] = "Current Budget")[Value])},
    {"Current Forecast", each List.Sum(Table.SelectRows(_, each [Versions] = "Current Fcst")[Value])}
    })
in #"Grouped Rows"