PowerBI codebase

DAX calculations

1 – Dax formula to calculate distinct status of the items

count_distinct_status = DISTINCTCOUNT(workshop_training[status])

2 – Dax formula to calculate days between when the item is first created till it is last tracked

date_diff_create_lasttracked = DATEDIFF(max(workshop_training[creation_time]), max(workshop_training[last_tracking_event_time]),DAY) 

3 – Dax formula to calculate the amount of items delivered

delivered_items = CALCULATE(sum(workshop_training[value]),filter(workshop_training,workshop_training[status]="delivered") )

4 – Dax formula to calculate the amount of items in transit

in_transits_values = CALCULATE(sum(workshop_training[value]), filter(workshop_training,workshop_training[status]="in transit"))