Calculation groups or Unpivot
Hi, I have a data set of monthly Stock data. It is a flat table of about 250,000 lines. Every line contains, besides the basics: date, stockID, price, 100 featurs of the stock. Things like Pricer/Earing ratio, market cap, etc. My task is to create measures such as TopN based summations based on these features. I have two choices (maybe more): 1) Unpivot the data and then have 25 mio lines with two columns feature_name and feature_value 2) Create a placeholder measure for every feature abd the use calculation groups (in the Tabular Editor) to create the requiered measures on SELECTEDMEASURE. Which one would you chose and why ? I'm particular worried about performance issues. Also the restrictions of using calculation groups. Many thanks in advanceTranspose or Upivot?
Hello everyone, I am hoping someone can help me with transposing or unpivoting some columns. I am basically trying to turn this: Into this in Power Query Editor: I've tried unpivoting a few different ways, but no luck with attaching the reponse and the commentary to the same Question and ID. Any help would be appreciated. Thanks!
Unpivot Column with Different Calculation Applied
Hi there, I am trying to unpivot data matrix using pwoer query but the data calculation is not only using summraize but also average since the value have different value format, iie. absolute number and percentage. Is it possible to apply this purpose using unpivot column in power query? Here is the data matrix example: I would like to convert (unpivot) and visualize the table into this: Kindly share your thoughts on this. Thank you in advance!Measures different in published report compared to desktop
Some measures seem to be calculating things differently in the published version of a report I have compared to what is appearing locally on desktop. The measures in the desktop version: 22.187%, -1.8350%, 22.594%. The measures in the published report are closer to 14%, -273%, and 54%. The data comes from sql server, which is then unpivoted in Power BI, and the measures are created based on the unpivoted data. Everything seems fine in Desktop, but in the published version I'm seeing very different numbers. Even weirder is I've tried to publish the report a few times and the measure will initially appear correct in the published version and then a few mintues later switch to being incorrect. Any ideas?
How to Unpivot the columns in Power BI Desktop
Hi All, I have calculated columns in Power BI Desktop Query. Now I want to unpivot/transpose the columns in another query. Is there any way to do this? I don't want to unpivot using M-Query but through derived table in 'Fields' pane of Power BI Desktop. Derived table should look like below screenshot where Filter_Name and Value columns are unpivoted columns. Base query has multiple columns covered under column Filter_Name and Value column is the actual value of the respective column.
Bypass an explicit filter to have a global total
Hi, I have a view where I show a total of spendings per month. Then I divide this total in four categories in the purpose of separate spendings less than, equal to (not remarquable), without comparision with or greater than the previous month. My objective is to show uniquely the values where the variation to the previous month is greater than 1% of the total of the current month. For instance, the first line of the category (Inferiores mas de 10% al mes anterior) is correct because the variation is greater than the total (30 970 000 / 100 = 309 700) but the fourth one is not supposed to appear. ((616 000 - 501 000) < 309 700) My measure for the total global is this : Mes actual general = CALCULATE([Mes actual], ALLSELECTED('Facturas Proveedores')) My issue is that when I use my measure "Total mes actual" which is supposed to be global, I have the total of the filtered category. I know that it is the normal behaviour of ALLSELECTED because we cannot remove the explicit filters however I would like to find a way to get this global value, either with DAX or modeling or any proposition you can make. Thanks !
Calculating percentage off of a measure in a table
Hello, I have a regular table visual that contains an unpivot column (Grade, Gender) and a measure to calculate students who attend the school more than 90% of the time (which is based on IDs and a few other calculated columns). I am trying to currently do a percentage of that measure on the unpivot column in the visual. However, it is not coming up accurately since the denominator is duplicating records for the unpivot column. However, I have been unsuccessful so far. Any help would be much appreciated.
