Convert SQL query to M language query

SaliyaWeera , Try this query,

let
    Source = Sql.Database("YourServerName", "YourDatabaseName"),
    Query = Source{[Schema="LEXDEV_MSCRM",Item="LEXQueryCRM_File"]}[Data],
    Top100Rows = Table.FirstN(Query, 100),
    FindNextEvent = (FileIdentifier) =>
        let
            FilteredEvents = Table.SelectRows(Query, each [FileIdentifier] = FileIdentifier and Date.From([Start Date]) > Date.From(DateTime.LocalNow())),
            NextEvent = if Table.IsEmpty(FilteredEvents) then null else List.Min(FilteredEvents[Start Date])
        in
            NextEvent,

    FindLastEvent = (FileIdentifier) =>
        let
            FilteredEvents = Table.SelectRows(Query, each [FileIdentifier] = FileIdentifier and [Event Type] <> "Event Reminder -" and Date.From([Start Date]) <= Date.From(DateTime.LocalNow())),
            LastEvent = if Table.IsEmpty(FilteredEvents) then null else List.Max(FilteredEvents[Start Date])
        in
            LastEvent,

    AddedNextEvent = Table.AddColumn(Top100Rows, "Next Event", each FindNextEvent([FileIdentifier]), type datetime),
    AddedLastEvent = Table.AddColumn(AddedNextEvent, "Last Event", each FindLastEvent([FileIdentifier]), type datetime),
    ReorderedColumns = Table.ReorderColumns(AddedLastEvent, {"FileIdentifier", "Next Event", "Last Event"}),

    SortedTable = Table.Sort(ReorderedColumns, {{"FileIdentifier", Order.Ascending}})
in
    SortedTable

Thanks. Unfortunately this DAX query did not work. When ran it in PBI Desktop it ended up with an error message. Error message is showb below.
The syntax for ',' is incorrect. (DAX(Sql.Database("JUVLEX12", "LEXDEVReports_MSCRM"), Query = Source{[Schema="LEXDEV_MSCRM",Item="LEXQueryCRM_File"]}[Data], Top100Rows