count of outlets like once , twice, thrice

[kumar1985]

Hi,

Please help me to count of outlets, like once , twice or thrice in specific period or dynamic period

Brand	Channel	Calendar Day	Outlet Code
Real 200ml	RTL	25.01.2022	0022002664GUW0AS00049668
Real 200ml	SS	21.01.2022	0022002664GUW0AS00251223
Real 200ml	SS	11.02.2022	0022002664GUW0AS00251223
Real 200ml	RTL	04.01.2022	0022002664GUW0AS00258548
Real 200ml	RTL	16.02.2022	0022002664GUW0AS00258548
Real 200ml	RTL	08.01.2022	0022002664GUW0AS00267374
Real 200ml	RTL	19.02.2022	0022002664GUW0AS00267374
Real 200ml	RTL	21.02.2022	0022002664GUW0AS00267374
Real 200ml	RTL	21.03.2022	0022002664GUW0AS00267374

Result like

Slab	Nos of outlet	Period
Once billing	1	Jan to Mar
Twice billing	2
Thrice billing	3

Regard

Jay

[kumar1985]

I Want result like how many outlets repeat once, twice or thrice?

[kumar1985]

Hi, I m new power BI user please help me to solve the issue

[Anonymous]

Hi @kumar1985 ,

Any updates?

As @lbendlin mentioned, we need more detail information(tables, logics, outputs...) to help us clarify your scenario. Or you could share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Eyelyn Qin

[lbendlin]

Welcome to the forum.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[kumar1985]

waiting

Calendar Day	Outlet Code
25.01.2022	0022002664GUW0AS00049668
21.01.2022	0022002664GUW0AS00251223
11.02.2022	0022002664GUW0AS00251223
04.01.2022	0022002664GUW0AS00258548
16.02.2022	0022002664GUW0AS00258548
08.01.2022	0022002664GUW0AS00267374
19.02.2022	0022002664GUW0AS00267374
21.02.2022	0022002664GUW0AS00267374
21.03.2022	0022002664GUW0AS00267374

Slab	Nos. of outlet	Period
Once billing	1	Specific Period( 01.01.2022 to 31.03.2022
Twice billing	2
Thrice billing	1

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?