How to write dax expression that filter dates in Power BI

[Anonymous]

Please I have this block of code in C#, I want to rewrite this in Power BI, but do not know how to filter the workdate.

var pallets = from a in _context.WorkRecordFacts
                      join b in _context.Activities on a.ActivityId equals b.Id
                      join c in _context.Buildings on a.BuildingId equals c.Id
                      join d in _context.BusinessUnits on c.BusinessUnitId equals d.Id
                      join e in _context.EmployeeStatuses on a.EmployeeId equals e.EmployeeId
                      join f in _context.Positions on e.PositionId equals f.Id
                      join g in _context.Uoms on a.Uomid equals g.Id
                      where a.WorkDate >= e.StartDate && a.WorkDate <= e.EndDate
                      where a.WorkDate != DateTime.Parse("0001-01-01")
                      where a.WorkDate >= model.StartDate && a.WorkDate < model.EndDate
                      where f.Code != "CSR"
                      where b.ReportingType == "Regular"

This is the part I need help with

This is my dax but the output is not correct.

TotalDHrs =

               var employee = [EmployeeId]

               var workDate = [WorkDate]

               var statuses = FILTER(ALL(EmployeeStatuses),

               EmployeeStatuses[StartDate] <= workDate

               && EmployeeStatuses[EndDate] >= workDate

               && EmployeeStatuses[EmployeeId] = employee)

               var result = CALCULATE(SUM(WorkRecordFacts[DurationHours]),

              statuses, WorkRecordFacts[PositionCode] IN {"WHSE", "TMP", "SPT"}, WorkRecordFacts[ActivityCode] <> "CS")

              return result

I also need to arrange the workday in the right order. Any help will be appreciated.

[Anonymous]

Hi @Anonymous,

Can you please share a pbix or some dummy data that keep the raw data structure and relationship mappings? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Anonymous]

@amitchandak @Greg_Deckler @Mikelytics @MFelix @Jihwan_Kim