Forum Discussion
Convert measure into a For loop with IF Condition
Hello Community, I want to to loop in this condition because it always gaves me '1' as a result. MR2 =
Var mr365 = [MR/365]
RETURN
IF ( mr365<1,1,mr365) This is [MR/365] it's Me...
Hi DYY94 ,
Since I don't know how your [MR/365] metric was created, in the sample file on my side, it seems to be fine.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Thanks for your reply !
Yes the code works fine like that but when i used it in other table it gave me always '1' for all columns.
I have shared a simplified file to understand more the issue.
https://drive.google.com/file/d/1ZgsfLABoWKLXWfuh-A3SslgmZmAd0c40/view?usp=sharing
Thanks.