Forum Discussion
Nested If condition
Hi All, How to make nested if condition in Power BI. I have to create condition as : If (Amount is <=1000 and Year is MaxYear) , If(Amount is between <1000 and Year = MaxYe...
I have created period logic but if not showing elements. PF pbix file for details.
https://www.dropbox.com/s/uji1sv4dcfuprhv/period.pbix?dl=0
Thanks,
R_
Hi R_
In this case your requremens still are not clear for me. I've changed formula but based on yuor data only period1 can be reached or blank.
Bucket = IF(and(Data[Amount] <= 1000, Data[year] = MAX(Data[year])-1),"period1",IF(and(Data[Amount] <= 1000, and(Data[Amount] >= 2000, Data[year] = MAX(Data[year])-1)),"period2",BLANK()))