Forum Discussion

vishy0501's avatar
vishy0501
Icon for Helper I rankHelper I
6 years ago

Condition Breach Rule - DAX conditional Lookup

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 ...
Dax Help
kentyler's avatar
kentyler
Icon for Solution Sage rankSolution Sage
6 years ago

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's avatar
vishy0501
Icon for Helper I rankHelper I
6 years ago

Hi kentyler  - 

 

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