Condition Breach Rule - DAX conditional Lookup

[vishy0501]

Hi 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 Plan	MI_SUBSCRIPTION_ID	CHARGED_MB	UNIQUE_CALLS	TOT_INCOMING_CALLS	TOT_OUTGOING_CALLS	OG_CHARGED_MINS	IC_CHARGED_MINS	MI_FROM_DATE	MI_TO_DATE	Abuser Descr
Rose	1	2	3	4	5	6	7	01-Oct	31-Oct	Fair Use
Rose	1	3	4	5	6	7	8	31-Oct	30-Sep	High Risk
Lotus	3	4	4	7	9	8	12	01-Oct	30-Nov	High Risk
Rose	1	12	3	4	5	5	6	01-Aug	30-Aug	High Risk

[kentyler]

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 ?

[vishy0501]

Hi @kentyler  - 

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