How to replicate Parameters (tableau) in Power BI?
This is the parameter created in Tableau and I want to create something similar in Power BI, as this parameter is then used to calculate a field called PLAN as below: What is the best way I can achieve this in Power BI? I want to use this field "Plan" (sum) as my column value.
Coloring cells / columns based on standard deviation of window values
Hi, I am working on moving some of our dashboards from Tableau to PowerBI, but I am struggling to find a way to do this. I have the margin of multiple products, and I want to compare it for different regions. I want to highlight those regions performing well and those underperforming. How can I do something similar in PowerBI? (Below is the tableau equivalent). Thanks, Daniel This is the view I have in Tableau Where Profit % = SUM(Profit) / SUM(Sales) and Color = IF ([Profit %]) > (WINDOW_AVG(([Profit %]))+0.75*WINDOW_STDEV(([Profit %]))) THEN "Green" ELSEIF ([Profit %]) < (WINDOW_AVG(([Profit %]))-0.75*WINDOW_STDEV(([Profit %]))) THEN "Red" ELSE "Neutral" END
Converting Tableau measure to Power bi
I am new to power bi and I need help with converting this Tableau measure to Power bi. This is the Tableau measure COUNTD(if ISNULL([EmployeeTerminationDate])=FALSE and [Fiscal Year]=[FiscalYearNumber (tbl Calendar)] and [Fiscal Week]=[Term Week] then [EmployeeJDENumber] else null end) Thank you, KushTableau's Include function in Power bi
Hi community I have this Tableau Code In which we use COUNTD and INCLUDE. I am unable to convert this function into Power bi. I shall be very thankful for any help. Thanks in Advance. IF COUNTD([Area Upper]) > 1 THEN IF ISNULL(MIN({include [Area Upper]:sum([Nominator])})) THEN NULL ELSE IF ISNULL(MIN({include [Area Upper]:sum([Denominator])})) THEN MIN({include [Area Upper]:sum([Nominator])}) ELSE MIN({include [Area Upper]:sum([Nominator])}/{include [Area Upper]:sum([Denominator])}) END END ELSEIF COUNTD([Sub Zone]) = 1 THEN IF ISNULL(MIN({include [Sub Zone]:sum([Nominator])})) THEN NULL ELSE IF ISNULL(MIN({include [Sub Zone]:sum([Denominator])})) THEN MIN({include [Sub Zone]:sum([Nominator])}) ELSE MIN({include [Sub Zone]:sum([Nominator])}/{include [Sub Zone]:sum([Denominator])}) END END ELSEIF COUNTD([Zone]) = 1 THEN IF ISNULL(MIN({include [Sub Zone]:sum([Nominator])})) THEN NULL ELSE IF ISNULL(MIN({include [Sub Zone]:sum([Denominator])})) THEN MIN({include [Sub Zone]:sum([Nominator])}) ELSE MIN({include [Sub Zone]:sum([Nominator])}/{include [Sub Zone]:sum([Denominator])}) END END ELSEIF COUNTD([Area Upper (group)]) = 1 THEN IF ISNULL(MIN({include [Zone]:sum([Nominator])})) THEN NULL ELSE IF ISNULL(MIN({include [Zone]:sum([Denominator])})) THEN MIN({include [Zone]:sum([Nominator])}) ELSE MIN({include [Zone]:sum([Nominator])}/{include [Zone]:sum([Denominator])}) END //MIN({include [Zone]:sum([Nominator])}/{include [Zone]:sum([Denominator])}) END ENDPercent Return for last 5 trading days (Base Price as of Earliest Date)
How can I make PxBase (base price) the same for all cells (according to earliest day price) In Tableau, I would do this. How do I do it in Power Bi? { FIXED [Ticker] : SUM( IF [Date.Index] = [MinDate] THEN SUM([Close) END) } My current measure formula are as below. The raw date range is from 2020 to 2022, thus I created an index column in the table to calculate the last 5 trading days for each ticker (dates are non-continious due to weekends and holidays in different stock markets). PxCurrent = VAR MaxIndex = CALCULATE( MAX(IndexETF_L2Y[Index]), ALLEXCEPT(IndexETF_L2Y,IndexETF_L2Y[Ticker]) ) VAR CurIndex = CALCULATE( MIN(IndexETF_L2Y[Index]), ALLEXCEPT(IndexETF_L2Y, IndexETF_L2Y[Ticker], IndexETF_L2Y[Date.Index]) ) VAR Period = 5 VAR Counter = MaxIndex - CurIndex VAR CurPx = CALCULATE( SUM(IndexETF_L2Y[Close]), FILTER(IndexETF_L2Y, Counter <= Period) ) RETURN CurPx PxBase = VAR MaxIndex = CALCULATE( MAX(IndexETF_L2Y[Index]), ALLEXCEPT(IndexETF_L2Y,IndexETF_L2Y[Ticker]) ) VAR CurIndex = CALCULATE( MIN(IndexETF_L2Y[Index]), ALLEXCEPT(IndexETF_L2Y, IndexETF_L2Y[Ticker], IndexETF_L2Y[Date.Index]) ) VAR Period = 5 VAR Counter = (MaxIndex - CurIndex) VAR StartPx = CALCULATE( SUM(IndexETF_L2Y[Close]), FILTER(IndexETF_L2Y, Counter = Period) ) RETURN StartPx Ultimately, I want to divide PxCurrent / PxBase - 1 in order to get to the last 5 days percent change (pegged to starting date) chart like this: Grateful for any Power Bi Master's help.
Calculate Avg Per Category for All Stores (Other Category Not Displayed in Table)
I am in the process of migrating a dashboard fom Tableau to PowerBI. This is how the final result looks: Category Avg. of Work Orders Across all Stores Distinct Count of Work Orders for Selected Store Category 1 103.0 129 Category 2 33.1 42 Category 3 38.6 37 Category 4 16.9 35 Category 5 19.1 24 I am displaying the Top 5 Categories by Work Orders Volume for the Selected Store. I have a parameter filter that the user uses to select a store to compare against all other stores in the fleet. Here are how I am calculating these measures in Tableau: Measure How to calculate it Measure Aggregation Distinct Count of Work Orders for Selected Store IF([Store #]=[Store_Parameter]) THEN [Tracking Nbr] END Count Distinct Avg. of Work Orders Across all Stores {INCLUDE [Store #] : COUNTD([Tracking Nbr])} Average I am having a hard time replicating this in PowerBI as I have been searching and nothing comes up with the result I need to display.Joining Salesforce Data to Excel Sheet Data
Hi everyone! I am looking to see if PowerBI supports joining two unrelated data tables into one project. I want to pull in data from a Salesforce sandbox, as well as an excel sheet. I then want to join this data into one table. I was able to do this with Tableau, so I'm hoping PowerBI has a way!
