Forum Discussion
alforrester
5 years agoNew Member
Error Comparing Two Dates in a Table
I want to compare two dates in a table in a formula like this:
Balance Change = if('BSResults'[As of Date]='BSResults'[StartDate],0,[Change in Balance]), but I get an error message that says "Cannot find name" for either of the fields, which do exist in the table
You need to post this on the power bi Desktop Forum. https://community.powerbi.com/t5/Desktop/bd-p/power-bi-designer
hope you are creating a new column not measure. Also, try to select a column name from the list when start typing it will suggest
1 Reply
- amitchandakSuper User
You need to post this on the power bi Desktop Forum. https://community.powerbi.com/t5/Desktop/bd-p/power-bi-designer
hope you are creating a new column not measure. Also, try to select a column name from the list when start typing it will suggest