topic Re: DAX to find out Deals added and Slipped every week in DAX Commands and Tips

DAX to find out Deals added and Slipped every week

KRISH80 — Sun, 15 Mar 2020 12:50:24 GMT

Dear All,

We run a commit report every week. Which will give us list of deals commited by our sales leaders for closure for that week. But not necessarily all the deals marked as commit in the week gets closed. Many of the deals get slipped to a future date. Next week again some new additions will come in. So what i want is below :

1. I need to identify which are the deals got added this week in our commit report which were not present earlier week

2. I need to identify which are the deals got slipped to future date from our commit report as compared to previous week

3. Sum total of all the deals added duirng the week

4. Sum tottal of all the deals slipped duirng the week

5. I also need a monthly view, which will tell me , these are the list of deals got added to the commit report in this month

6. I also need a monthly view, which will tell me, these are the list of deals got slipped to a future date in this month ( here we need to pick deals which were slipped to a date > this month)

7. Sum total of all the deals added duirng this month

8. Sum tottal of all the deals slipped in this month

I have a calendar table and all the cacluation here is based on the close date of the deal.

Re: DAX to find out Deals added and Slipped every week

Greg_Deckler — Sun, 15 Mar 2020 13:29:55 GMT

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Re: DAX to find out Deals added and Slipped every week

KRISH80 — Sun, 15 Mar 2020 15:30:39 GMT

Just to be very clear on my ask. Please see below table#1 is a previous week commit table.

In table #2 a new deal (row#8) got added, so i need to mark that deal as "Newly added" and then mention what is the total "Newly added" for the week & month

In table #3 a deal has got pushed out of March month to April ( row #3), so i need to mark that deal as "Slipped" and then mention what is the total "Slipped" for the week & month

Re: DAX to find out Deals added and Slipped every week

Greg_Deckler — Sun, 15 Mar 2020 15:38:27 GMT

KRISH80 - Yes, but I don't want to have to type all that. I just want to copy and paste.

Re: DAX to find out Deals added and Slipped every week

KRISH80 — Sun, 15 Mar 2020 15:48:48 GMT

Greg_Deckler, can you kindly let me know how can i share the contenet with you ? please. if you can give me your email id i will email it to you.

Re: DAX to find out Deals added and Slipped every week

Greg_Deckler — Sun, 15 Mar 2020 15:53:05 GMT

gdeckler@fusionalliance.com

Re: DAX to find out Deals added and Slipped every week

KRISH80 — Sun, 15 Mar 2020 17:15:26 GMT

Greg_Deckler i have sent you the file. Kindly help