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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
vishy0501
Helper I
Helper I

Condition Breach Rule - DAX conditional Lookup

test.PNGHi ALL,

 

I am stuck  with a scenario wherein I need to identify whether the user has breach a particular condition in previous month.

In the dataset i have three rows for each user for three month. Each month the fact value is different and i have created a calculated column which tells whether the user adheres or not . Based on that calculated column i need to find how many times the user has breached the policy. So if the user has "HIGH risk" as the value in that column in past two months I need to highlight that particular user..

 

Note I have two different date columns and it needs to be calculated using these two different date.

 

Attached is the sample dataset as well

 

Name PlanMI_SUBSCRIPTION_IDCHARGED_MBUNIQUE_CALLSTOT_INCOMING_CALLSTOT_OUTGOING_CALLSOG_CHARGED_MINSIC_CHARGED_MINSMI_FROM_DATEMI_TO_DATEAbuser Descr
Rose123456701-Oct31-OctFair Use
Rose134567831-Oct30-SepHigh Risk
Lotus3447981201-Oct30-NovHigh Risk
Rose1123455601-Aug30-AugHigh Risk
2 REPLIES 2
kentyler
Solution Sage
Solution Sage

your second row covers 2 months, 31 oct -> 30 sept, is both oct and sept. what is your logic for determining the "month" of each row ?





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Hi @kentyler  - 

 

I am using Single active relationship between my date dim and from date. And calculating the values accordingly.

 

Image.PNG

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.