Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Frequent Visitor

how to leave existing data after IF ELSE function

I'm extracting data off a sharepoint list where the status change of each issue is updated as the issues are fixed. 

I'm trying to keep a daily record of the count of each status,

Is there a way for it to count IF the date is today, ELSE leave the existing data? 




Super User
Super User

@ben-t , What column you want leave put that in else



if([Date] = today() , counrows(filter(<Your code>)), [Column 1])


I want to keep the data in the same column that was written the day before. 

the code that i've written only writes to today's date, then for every other date it wipes the values. 

i tried selecting the same [completed] column in else, but there seems to be an error. 


If not, is it possible to write this row of data to a new sharepoint list? 

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.