Forum Discussion
IF ELSE
do you guys have an idea how to get this formula in Power BI? if [SHIP_DATE]>TODAY()-1 then 'Current' ELSE 'Overdue' end
HI Anonymous
If you are looking to create a measure , here is the formula:
Date_fltr_measure = IF(max(Max_Grp1[Date])>TODAY()-1,"Current","Ovedue")If you are looking to create calculated column, here is the formula:
Date_fltr_column = IF(Max_Grp1[Date]>TODAY()-1,"Current","Ovedue")Thanks
Raj
HI Anonymous
If you are looking to create a measure , here is the formula:
Date_fltr_measure = IF(max(Max_Grp1[Date])>TODAY()-1,"Current","Ovedue")
If you are looking to create calculated column, here is the formula:
Date_fltr_column = IF(Max_Grp1[Date]>TODAY()-1,"Current","Ovedue")Thanks
Raj