Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Need to count frequency of Occurrence before certain date
Example,
Input
Name Date
Test1 29-01-2022
Test2 30-01-2022
Test3 30-01-2022
Test1 30-01-2022
Test1 31-01-2022
Test4 01-02-2022
Test3 01-02-2022
Test5 02-02-2022
Name Date count Frequency (Name)
(this column is not availble in the table and caluculatin this is not working with 5L+ Entries)
Test1 29-01-2022 1
Test2 30-01-2022 1
Test3 30-01-2022 1
Test1 30-01-2022 2
Test1 31-01-2022 3
Test4 01-02-2022 1
Test3 01-02-2022 2
Test5 02-02-2022 1
Required Output
Count of Frequency greater than 1 = 3
Thanks in Advance.
Solved! Go to Solution.
This should be just a simple count of rows with specific criteria.
Frequency :=
VAR _Test = Table[Name]
VAR _Date = Table[Date]
RETURN
CALCULATE(COUNTROWS(ALL(MyTable)),
MyTable[Name] = _Test,
MyTable[Date] <= _Date)
This should be just a simple count of rows with specific criteria.
Frequency :=
VAR _Test = Table[Name]
VAR _Date = Table[Date]
RETURN
CALCULATE(COUNTROWS(ALL(MyTable)),
MyTable[Name] = _Test,
MyTable[Date] <= _Date)
didn't understand MyTable??
Is this measure or formula for column?
It's a formula for a custom column. And since I don't know how your table is called, I used "MyTable" instead.
@ashaykohad , Create a measure like
Sumx(filter(addcolumns(summarize( Table, Table[Name], Table[Date]), "_1", count(Table[Name])), [_1] >1), [Test])
What is last [Test]!!
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |