Calculate variance between two Matrix in Power Bi
I have two matrixes in power Bi user can choose a forecast from point in time and select which month to see the results. from 1st slicer they choose the first creation date (year and Month) then they choose which month to see the forecasts for in the 1st matrix same for the 2nd matrix for a different point in time so, we end up with two matrixes. how can I calculate the variance between these two matrixes? Thanks results
DAX Lookup Value in another table with filter (calculated column)
Hi all, I have the following tables, relationships and data: Project: Task: ProjectPhaseSummary: I want to add calculated columns to "ProjectPhaseSummary", so that I end up with the following: Hoping someone can please suggest the most accepted way of generating the information above with DAX (preferably using CALCULATE). Thanks, Ben.
Hep with the formula
Anonymous Anonymous CarlossSainz Hi I have a formula below for calculating the sum of gross risk potential in the table. I want the sum calculation based on the risk name instead of summing up the entire column. I tried the below formula but it is not giving the correct value. I can give an example The total sum of gross risk potential is 100. But the gross risk potential for risk A is 20. I want to get this separate value for all the risks i have in a single column without creating multiple columns. TotalRiskPotentialPerRisk = SUMX( VALUES(Top_Risk_Controls[Riskname]), CALCULATE( SUM(Top_Risk_Controls[Gross_risk_potential]), Top_Risk_Controls[Riskname] = EARLIER(Top_Risk_Controls[Riskname]) ) ) In the above formula, im getting the same values as the gross risk potential column instead of the sum of them based on the risk name. How to get the sum of the values based on the risk name. Please note that the data source is the sharepoint list.
Get SUM of compound rate calculation with numeric field
Hi all, please see below one example data set: Year Value FC-Flag 2010 23 2011 43 2012 23 2013 45 2014 67 2015 54 2016 54 1 2017 54 1 2018 54 1 2019 54 1 2020 54 1 2021 54 1 2022 54 1 2023 54 1 With that data i do calculate firstly a measure that displays only the Forecast Values: FC = CALCULATE(SUM(Tabelle1[Wert]),NOT ISBLANK(Tabelle1[Flag])) That measure i use to calculate the actual compound interest values in combination with a Numeric Range user input (Index Value): Wage Indexed = VAR selectedyear = SELECTEDVALUE('Date'[Year]) VAR currentyear = 2015 // this might need to be calculated VAR rate = DIVIDE([Index Value],100) RETURN [Wages] * POWER((1 + rate),selectedyear-currentyear) Thats works fine for displaying the values in a table/chart and the values are calculated as expected. However when I try to get the sum over the years this measure returns 0 - and i didn't manage to adjust the query to also return a sum over the years. Example screenshot: I'm trying to get the SUM for the values in each year in the Total(Gesamt) column. As you can see currently, it doesn't work like that. Would appreciate any help/idea how to get the sum in combination with calculating the compound interest with a numeric field (user input). ThanksSplit Text into rows using DAX
Hi power BI expert, I need to split into rows using DAX instead of using Power Query due to performance (the data is too large). For info, previously i was using Power Query but I'm keep getting error messages saying about performance. Below is my sample data: There is some calculation that i need to do once names splitted into rows. Really need anyone help to achieve this Thank you
TotalMTD , TotalYTD is very slow for a specific table
I created following measure in 2 tables, orders and shipments. Both are showing correct value. However measure in orders loads very fast but same measure formula in shipments is extremely slow TOTALMTD( orders[amount], calendar[date]) time : 1524 is very fast but TOTALMTD (ship[amount], calendar[date]) is slow time :6454 calendar is not marked as date table because it is having duplicates. i don't mind, because it is showing correct values
