Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I
Helper I

Sharepoint site file source and else-if calculated field

Hello Dear Community!


I started to get familiarize Power BI just a few months ago and I would like to build a dashboard, which uses excel files from Sharepoint sites which are refreshing in a daily bases and after this refreshment, they got a new file name. I added the most actual file's path to the Power BI, it is working well, but obviously I will cannot use the Refresh button, as the path will change every day. Does anyone has a solution for that?


My other question is related to calculated columns. My goal would be, that in this column get a calculated value, if a condition is valid:

if XY column (with string data), contains 80M, then this calculated new column = WZ (with number data) *1.6, else this calculated new column =WZ


I tried to find the solution in several sources, but now I am a little lost 🙂


Thanks for any help a lot!






Super User
Super User

Hello @anettpb ,


check if this article would help in your case


If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin

Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!

Hello @Idrissshatila 


Thanks a lot for this guidance, I will try it, but at first sight it seems a little bit complex to me, as I am a really beginner 😄

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors