cancel
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.

Reply
anettpb
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!

 

BR,

Anett

 

 

2 REPLIES 2
Idrissshatila
Super User
Super User

Hello @anettpb ,

 

check if this article would help in your case https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters

 

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

Announcements
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