Johannesburg Fabric / Power BI User Group Meeting
Please join us at 17h00 on the 31 st of August for our next Power BI User Group event. As an "even" month, this will be a purely online event. The Zoom details can be found on the Meetup page, using the URL below. The agenda for the August event is as follows: BI News by Siya Zungu Power BI and Tableau - key differences from a BI developer's point of view by Christelle Els For more information, and to RSVP, please use this Meetup link: https://www.meetup.com/biug-sa/events/295383113/Johannesburg Fabric / Power BI User Group Meeting
Please join us at 17h00 on the 31 st of August for our next Power BI User Group event. As an "even" month, this will be a purely online event. The Zoom details can be found on the Meetup page, using the URL below. The agenda for the August event is as follows: BI News by Siya Zungu Power BI and Tableau - key differences from a BI developer's point of view by Christelle Els For more information, and to RSVP, please use this Meetup link: https://www.meetup.com/biug-sa/events/295383113/
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.
