User Profile
SNad_11
New Member
Joined 3 years ago
User Widgets
Contributions
Re: Nested IF/AND Statement Help
Thanks Bifinity_75! That worked for me, also have tried this and this worked too: if [Percent_Complete]=1 then "Complete" else if [Baseline_Date]>= [Forecast_Date] then "On Track" else if [Baseline_Date]>[Today] and [Forecast_Date]>[Baseline_Date] then "At Risk" else if [Baseline_Date]<[Today] then "Missed" else ""2.1KViews0likes0CommentsNested IF/AND Statement Help
Hello everyone, I am trying to find the best way to translate the below excel formula into PowerQuery in PowerBi. The data is project and date information and essentially the formula looks and compares dates against one another to provide a status. I appreciate that the syntax for IF statements in PowerQuery is 'if x then x else x'. In Excel it is expressed as follows: =IFS([@[% Complete]]=1,"Complete",[@[Baseline_Date)]]>=[@[Current Forecast]], "On Track",AND([@[Baseline_Date)]]>TODAY(),[@[Current Forecast]]>[@[Baseline_Date]]),"At Risk",[@[Baseline_Date]]<TODAY(),"Missed"). Any help would be much appreciated!Solved2.1KViews0likes3Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.