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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
ben-t
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? 

thanks

bent_0-1626050639938.png

 

2 REPLIES 2
amitchandak
Super User
Super User

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

 

example 

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

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.