User Profile
OsmanEmi
Frequent Visitor
Joined 5 years ago
User Widgets
Contributions
Using OR function within Text.replace function - Power Query
Hi, I'm sort of new to power query and while adding a new column I used the below function which works, however I wanted to ask if their was a way to also replace more than one value. = [#"DestinationType"] & " | " & Text.Replace([#Destination Name], "Spend", "Facts") Would need to be = [#"DestinationType"] & " | " & Text.Replace([#Destination Name], "Spend" OR "App" OR "Card" , "Facts") Is this possible to do in one step?Solved5.3KViews0likes3CommentsM language Token EOF Expected
Hi, When trying to add a column in power query I'm met with the error "Token EOF Expected" I wanted to ask if the syntax I'm using is incorrect = ([#"DestinationType"] & " | " & [#Destination Name] text.replace([#Destination Name], "Spend", "Facts")Solved2.7KViews0likes1CommentHow to display additional information using Map visual
Hi, I'm using the built in Map visual to display stores on a map. My issue is that I'm using postcodes(UK) and can't display other stuff like store name on the map when a point is highlighted. I've tried to concatenate post code and store names but then it scatters some points to different countries. How would I also display storenames or is this a power BI limitation?Solved608Views0likes1CommentMeasure value is not dynamic when inserted into a table
Hi All, I'm trying to create a scoring system for my table with a measure however whenever i insert the measure into the table I get just 1 value for all as opposed to it being dynamic for all rows. Can someone explain the logic behind it and what I'm missing? Table and measure below, please note the -IN FULL (KPI) the measures refers too is also a measure and total value is 99. 1OIn Full Score = var OnTimeScore = 0 Return IF(-FACT_TRACKING_PERFORMANCE_UKIE[-IN FULL (KPI)] > 0.98, OnTimeScore + 0, OnTimeScore + 1) Restaurant KPI Score 1 98% 1 2 90% 1 3 94% 1 4 99% 1Solved635Views0likes2CommentsVariable Usage - (VAR)
Hi, I'm trying to understand variable usage and tried creating the mesaure below however, when put into a table the result is true/false as opposed to value. Please can you explain where i'm going wrong and if my logic is flawed. Measure is below the Target% measure is a % Scoring System = var CurrentScore = 0 Return IF(Target[Target%] > 0.98, CurrentScore = CurrentScore + 0, CurrentScore = CurrentScore + 1)Solved901Views0likes2CommentsSuitable Visual Replacement
I'm currently working on a Restaurant based delivery dashboard that displays the ammount of times a delivery was late. The left side represents the number of times the late occured and each number within the sector is a card with a filter to the data column e.g. Lates > 4, Lates = 3 and so on. Everything seen in the chart above is lines text boxes and custom made which i believe is not the best way to vissually represent this scenario. I wanted to ask if there was a more suitable visual to use for this purpose. Additional Info: - The Data colum is called Lates and is a numeric column.Solved1KViews0likes3CommentsFiltering error based on two columns
Hi, I have the below dax expression and am trying to filter based on two rows however I get an error with the second filter that states "A Function Filter has been used in a true or false expression" Can someone explain to me the logic behind what im doing and why it's wrong. Below is my dax measure -Crew NA. = CALCULATE(COUNT(FACT_DELIVERY[CREW_QTY]), FILTER(ALL(FACT_DELIVERY[CREW_QTY]),FACT_DELIVERY[CREW_QTY]<2) && FILTER(ALL(FACT_DELIVERY[STOP_TYPE]),FACT_DELIVERY[STOP_TYPE] <> "C")) Below is an example table: Crew_qty stop_type 1 c 1 a 2 a 3 aSolved1.1KViews0likes4Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.