Forum Discussion
Create column, Display Data from another column if current month, otherwise blank
Hi! I try to explain this. :manvery-happy: I would like to create a new column which shows data from another column (sales) IF that sale has happened in current month OTHERWISE blank cell. ...
Please look into this formula, it may helps you...
Datef = IF(CurrentMonth[Date] < [SM] , BLANK(), CALCULATE(SUM(CurrentMonth[Sales]), DATESBETWEEN(CurrentMonth[Date], [SM], MAX(CurrentMonth[Date]))))
When i try to your reuqirement, as you mention above like "Blank"....
it throughs error, why because not retrun text and calculation as well as.
see error below...
It it is solution to your query. Please accept as a solution, it is helpful to others.....
