Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
pra137
Helper III
Helper III

Count ip address between 2 dates columns

Hello guys,

I want to calculate the count of ip address  which is repeated between 2 dates columns I means if 10.10.177.153 is an ip address how much time it is repeated  between creation date column and creation date  before 90 days ..column 

Plz.help how to do this..

 

1 REPLY 1
amitchandak
Super User
Super User

@pra137 , if you need a new column then  try a column like example with correct column names

 

New column =

var _ip = [ip]

var _dt = [Date] -90

var _dt2 = [Date]

return

countx(filter(Table, [ip] =_ip && [Date] >=_dt && [Date] <= [_dt2] ), [Ip] )

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.