Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
I am in need of help making a measure that marks each point in time an ID reoccurs. For example in the picture below i have 1 reoccurance of ID 1234 in which the ID repeats on the date Monday, July 01, 2013. I would like a measure that would log this and show a value of 1 at each date with a repeat ID.
Heres a link to the Power BI file and Excel File i am using; https://www.zeta-uploader.com/en/716253617
Solved! Go to Solution.
Hi @Kote101
If i undertsand you right, create measures as below
repeat = CALCULATE ( COUNT ( Sheet1[ID] ), FILTER ( ALL ( Sheet1 ), Sheet1[ID] = MAX ( Sheet1[ID] ) && [Date End] <= MAX ( Sheet1[Date End] ) ) ) show id = IF([repeat]>1,MAX(Sheet1[ID]),BLANK()) final show = IF([repeat]>1,1&" "&"ID:"&[show id])
If not, please let me know more details.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Kote101
If i undertsand you right, create measures as below
repeat = CALCULATE ( COUNT ( Sheet1[ID] ), FILTER ( ALL ( Sheet1 ), Sheet1[ID] = MAX ( Sheet1[ID] ) && [Date End] <= MAX ( Sheet1[Date End] ) ) ) show id = IF([repeat]>1,MAX(Sheet1[ID]),BLANK()) final show = IF([repeat]>1,1&" "&"ID:"&[show id])
If not, please let me know more details.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You should be able to use EARLIER for this. See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |