Forum Discussion
Roym
Helper IV
Helper IVNew calculated column disappears after enter
In my model I created a couple of measuers
[Quarter Year Reported] -> shows the quarter the row is reported
[Current Quarter and Year] -> Todays quarter based on todays date
[Quarter Year Closed] -> shows the quarter the row is Closed
Now I created a new calculated column:
Is New =
IF (
[Quarter Year Reported] = [Current Quarter and Year],
1,
0
)
This works perfectly. But when I try to create a new column with a similair code but then for closed it disapears after I press enter. I also tried changing the code above to show Is Closed and then it is working. So the fields itself are not the issue. For some reason adding two calculated columns is not working. Any idea what I can/need to do to solve this?
Is Closed =
IF (
[Quarter Year Closed] = [Current Quarter and Year],
1,
0
)
Roym , I really doubt, I have seen a problem like that
close all Power BI files. open and try again
If there are pending windows, patch, and install that
use the latest version of Power BI
1 Reply
- amitchandak
Super User
Roym , I really doubt, I have seen a problem like that
close all Power BI files. open and try again
If there are pending windows, patch, and install that
use the latest version of Power BI