DAX Help Sum of orders that should be Fulfilled (Closed) in year

Anything related to PowerPivot and DAX Formuale
ayman
Posts: 1
Joined: Sat Dec 29, 2018 2:52 am

DAX Help Sum of orders that should be Fulfilled (Closed) in year

Postby ayman » Sat Dec 29, 2018 2:55 am

Hello, I appreciate if someone could help in my request as I'm little bit new to DAX, in the below table I've some orders that were created in different years and it has not been closed until 2017/2018 (MaxlifeYear), I need to sum the orders balance for each MaxlifeYear, the order balance is the sum of orders its creation year less than or equal to the analyzing year and its maxlife year is equal to or greater than the analyzing year so if we are analyzing year 2017 i need the SUM of orders created 2017 and earlier and closed in 2017 and later

in the sample file attached the results should be as follow

Year Orders
2017 147,988
2018 67,480
Thanks
Attachments
Sample.xlsx
(11.64 KiB) Downloaded 12 times

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 2 guests

cron