MultiDateCounts

[Anonymous]

Hi,

I have data with multi status dates. When I try working dates individually they are working fine but when I try to combine multi date counts in a table or achart it is taking first column/axis as source. Please help how to achieve this, I am pretty new to Power Bi and DAX.

Number	Initiated on	Closed on	State	Week Start
MOC05172118	10/9/2020		Prossing	10/12/2020
MOC05176326	10/12/2020		Prossing	10/12/2020
MOC05178769	10/13/2020	10/13/2020	Completed	10/12/2020
MOC05185646	10/13/2020	10/13/2020	Completed	10/12/2020
MOC05192145	10/14/2020	10/23/2020	Completed	10/12/2020
MOC05192665	10/14/2020	10/22/2020	Completed	10/12/2020
MOC05199506	10/15/2020	10/23/2020	Completed	10/12/2020
MOC05199588	10/15/2020		Prossing	10/12/2020
MOC05201403	10/16/2020	10/16/2020	Completed	10/12/2020
MOC05204861	10/16/2020	10/16/2020	Completed	10/12/2020
MOC05206922	10/16/2020	10/16/2020	Completed	10/12/2020
MOC05211641	10/19/2020	10/20/2020	Completed	10/19/2020
MOC05215977	10/20/2020	10/20/2020	Completed	10/19/2020
MOC05222084	10/20/2020		Pending	10/19/2020
MOC05225207	10/21/2020		Pending	10/19/2020
MOC05227859	10/21/2020	10/21/2020	Completed	10/19/2020
MOC05231344	10/22/2020	10/23/2020	Closed	10/19/2020
MOC05232386	10/22/2020		Pending	10/19/2020
MOC05238856	10/23/2020		Prossing	10/19/2020
MOC05242399	10/23/2020		Allocated	10/19/2020

I am trying to achieve as below

10/12/2020	Count Initiated On	11
10/12/2020	Count Closed on	8
10/12/2020	SameDay Closed on	5
10/19/2020	Count Initiated On	9
10/19/2020	Count Closed on	4
10/19/2020	SameDay Closed on	2

[CNENFRNL · Accepted solution]

Hi, @Anonymous , both DAX and M do the trick with ease. you might want to refer to the attach file for details.

DAX solution,

PQ solution,

[Anonymous]

Seems having issues open the file, have restrctions. can please copy the conditions so I can relate. Appreciate.

Sincerely,

Krishna.

[Anonymous]

Hi, I am excited to look at the solution however I was not able to download the file. Requesting can please share the file again.

Look forward for your reply.

Sincerely,

Krishna. 

[CNENFRNL]

@Anonymous , I think I've linked the file correctly. 🤔

Or, you try this link directly,

https://1drv.ms/u/s!AsDP3LYI8umsgSWcrgaI4IH3BL2O?e=i99kbq

[Anonymous]

Appreciate for sharing, I was able to locate the file.

Thanks 

Krishna.

[Anonymous]

I was not able to open the file due to restrictions, requesting can please share the screen captures.

Thanks

Krishna.