Replicate Pivot into PowerBI and using DAX
Please assist: I have brought in the Pivot table as an example of what the PowerBI report should look like, see:https://drive.google.com/file/d/1_XyrEdRUsQImyuDhapkA5fqcpXRGUjRV/view?usp=sharing . My Fact Data, https://docs.google.com/spreadsheets/d/1mN6dGl4NY9N8yrXDpmx_CTJnZbxL61Zi/edit?usp=sharing&ouid=10412... Cash Flow tab in this file, https://docs.google.com/spreadsheets/d/1mN6dGl4NY9N8yrXDpmx_CTJnZbxL61Zi/edit?usp=sharing&ouid=10412... represents the final look with calculations as seen in my PBIX file. Source Data in the same file is my data in SQL DB. Please advise what will be the best way to get my data model/report aligned so that I can do the formulas in PowerBI using DAX as seen in the Cash Flow tab, column K.
Running Total per week/month
Hello, I would like to have a measure in power pivot for the running total that behaves like the one in the normal pivot tables. For instance, in the pivot table below the value are shown as running totals based on the week number (y axis). The running total is based on the week number, and for example after w6 in January it`s still reported the maximum value for the month. Here it's the most i managed to accomplish via power pivot: Here the code for the measure: ActualsRunningTotal:=TOTALYTD(SUM(Actuals[Volume]), Actuals[Date], ALL(Actuals)) Here the structure of the model, highlighted the fields i use in the pivot. I didn`t quite manage to find online how to handle this case, any ideas? Should i adjust the relationship between tables or use different functions? I`m doing it via power pivot because then i would need to combine the measure with other two, for which I only need the normal totals. Thank you in advance, any help is very much appreciated KR
Pivot Table Target Measure
Hi guys... I need your help with a measure in Pivot Table with Excel. My goal is to have a measure (DisplayTotalWeeks) based on qty of "SemanaMes". In the case, it must return 9 like the example below. Something like that: Criada em (Month) SemanaMes Qty Atividade DisplayTotalWeeks abr 1 446 9 abr 2 11 9 abr 3 1 9 abr 4 3 9 abr 5 1 9 mai 1 524 9 mai 2 701 9 mai 3 1 9 mai 4 2 9 Grand Total 1690 9 I have stressed ChatGPT, but it doesn't give me what I'm looking for. As an example, I have try this from GPT: TotalUniqueWeeks := COUNTROWS(SUMMARIZE('YourTable', 'YourTable'[SemanaMes])) DisplayTotalWeeks := CALCULATE([TotalUniqueWeeks], ALL('YourTable')) It doesn't return 9, that what I was expecting. So, you are my last hope.DAX Power Pivot
Hi I am using PowerPivot to build a pivot table. I am wanting to have a slicer based off a function so I can better filter my pivot table. Example: Is there a way to have a slicer that ties to the number in WKS_No_DATA? WKS_No_Data is a summed column on the pivot table. I would like to have a Slicer tied to any number that list in the WKS_No_Data so i can just filter on 1, 2, or 3) I know I can use a simple filter at the top of the pivot but i would like a slicer so the pivot still shows grand totals at the bottom and does all the normal calculations. WKS_No_Data 1 2 3 1 3 Thank you.
