DAX Fridays! #24: Running/ Cumulative totals (w Pareto chart)

Рет қаралды 62,528

Күн бұрын

In this video I will show you how to calculate cumulative totals or running totals with DAX/ powerpivot.
We will calculate running totals with a Date and with another column (not a date).
Link to Matt's Blog post: exceleratorbi.com.au/cumulativ...
Link to demo file: curbal.com/blog/glossary/calc...
05:22 Earlier - Dax Fridays: • DAX Fridays! #13: EARLIER
08:00 Rankx - Dax Fridays: • DAX Fridays! #9: RANKX...
PREVIOUS VIDEO: • DAX Fridays! #23: ISFI...
NEXT VIDEO:
Looking for a download file? Go to our Download Center: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: goo.gl/rvIBDP
► Facebook: goo.gl/bME2sB
#daxfridays #curbal #SUBSCRIBE
► Linkedin: goo.gl/3VW6Ky

Пікірлер: 167

@nathanielcongreso5378 3 жыл бұрын

Thanks you so much, you saved me for another day of work trying to figure out what to do :D , after 3 days of looking at so many tutorial, this is THE MOST effective and efficient.

@josepbravo643 4 жыл бұрын

Gracias, Thank You, Merci!! You saved my month! I've been looking for this solution for weeks with no success. Now is clear. I loved also the article from Matt. I just had to adapt the DAX formulas, since my report pages is already pre-filtered by a "main" page, so I have to use ALLSELECTED( to keep the right records. This is the first comment I write on your videos, although I like many of them. In summary, great work Ruth, keep moving!

@CurbalEN 4 жыл бұрын

Thanks for sharing your solution and saying hi 👋 /Ruth

@torben87 6 жыл бұрын

Great video! I really appreciate you going through the differences when using time and other ranking. And your use of TOPN is just brilliant. I didn't see that in any of the other posts and videos that I've found. Thank you!

@CurbalEN 6 жыл бұрын

You welcome Torben, glad you liked it :) /Ruth

@zhaoyong6715 5 жыл бұрын

agreed ... Thanks :)

@CurbalEN 5 жыл бұрын

:D /Ruth

@just4fun410 5 жыл бұрын

HI Curbal, I saw so many videos and blogs, but no use. But ur video gave me the solutions for my project. Superb Curbal. Thanks a Lot.. :)

@CurbalEN 5 жыл бұрын

Glad to hear that!! :) /Rutj

@nancmadi 4 жыл бұрын

OMG... you saved my life... everyone has told me Pareto don't exist in PBI... you made it happen we use them all the time !!! Thank you once again soooo very much!!! 💖

@CurbalEN 4 жыл бұрын

❤️ pleasure to be of help! /Ruth

@angiehall8777 5 жыл бұрын

Finally after watching various videos on this subject this formula worked for me! Thank you so much! :-)

@CurbalEN 5 жыл бұрын

Glad it worked for you :) / Ruth

@SmartBimson 7 жыл бұрын

Hey Ruth, it's already like with Pavlov reflex .. when I see Dax Friday it's the moment where I start my weekend :-) and actually this topic is again very interesting and cool explained 👍🏻🎉 have a great weekend and greeting !

@CurbalEN 7 жыл бұрын

+SmartBimson Hi SmartBimson! I didn't know what the Pavlov reflex was... until now! 😂 Oh Dear... think if I miss one Friday! 😱 Thanks for all your support and have a great weekend too! You make my Fridays w your comments:) /Ruth

@fcoatis 7 жыл бұрын

Another great video Ruth. Thank you for sharing.

@CurbalEN 7 жыл бұрын

+Fábio Coatis Thanks Fabio, have a wonderful weekend! /Ruth

@elmedex 3 жыл бұрын

after a week of tryinig to figure it out found this video and it really helped, I did a few tweeks acording to my business case but tis helped me a lot, muchas gracias

@CurbalEN 3 жыл бұрын

Todo un placer :)

@CloudhoundCoUk 7 жыл бұрын

Fabulous. Yet again an excellent explanation as to how to accomplish a complicated objective (cumulative totals).

@CurbalEN 7 жыл бұрын

+Cloud Hound Thanks Christopher and Happy Saturday! /Ruth

@CloudhoundCoUk 7 жыл бұрын

Always delighted to watch & learn when videos are produced, so well.

@CurbalEN 7 жыл бұрын

+Cloud Hound oh! Thanks Christopher! A lot of effort and enthusiasm goes into producing them 😊! /Ruth

@christopherflynn9811 4 жыл бұрын

I've learned so much from these videos, thank you so much for producing these. My question is what if i want to exclude the first 2 dates from the running total?

@alefcoimbra1440 6 жыл бұрын

Thank you very much. I've been using CALCULATE/DATESYTD in my running totals, but always got some bugs, specially when I use tables. Now the problem is all sorted out.

@sebastienschoonjans9727 2 жыл бұрын

Hi, thank you so much for the hard work and nice tips you provide! May I ask a question concerning the rank 3 item which is not included in the cumulative sum since both of items are ranked n°3 . We see that at the end of the video.

@Victor-ol1lo 7 жыл бұрын

Hi Ruth. Another great video. DAX Fridays! are really awsome! Running Total is a really interesting topic and very useful. Moving Annual Total and Moving Average could be further interesting topics. Best regards.

@CurbalEN 7 жыл бұрын

+Victor Friesen Thanks Victor, it is now on my to-do list. Have a nice weekend! /Ruth

@jochendecraene5519 4 жыл бұрын

Thank you for this great video and explanation!

@CurbalEN 4 жыл бұрын

Thanks to you for watching :) /Ruth

@amitshukla189 7 жыл бұрын

Thanks for sharing the video, 5 month before I struggled a lot to solve this , had to read a lot of blogs on PowerBI community and finally got the solutions. this video will help a lot of people.

@CurbalEN 7 жыл бұрын

+Amit Shukla Thanks Amit! If you know about other Dax Patterns I should do a tutorial on, please let me know! Have a great weekend :) /Ruth

@amitshukla189 7 жыл бұрын

+Curbal, Sure... in case if I have any doubt and looking for solutions to the problem where and how should I reach you?

@CurbalEN 7 жыл бұрын

+Amit Shukla Contact me @ Curbal.com/contact and I will give you my contact details! /Ruth

@amitshukla189 7 жыл бұрын

ok Ruth

@amitshukla189 7 жыл бұрын

Hi Ruth, awaiting your contact details

@deniskorolev9542 3 жыл бұрын

Awesome video, thanks! The main question is though: why bother with Running Total if you can use YTD (or MTD) ?

@powerbinareal Жыл бұрын

Sempre TOP! #powerbinareal ❤❤

@dasrotrad 5 жыл бұрын

Excellent! Thank you.

@CurbalEN 5 жыл бұрын

Glad it was useful Robert :) /Ruth

@NorbertoVeraReatigaNVR 7 жыл бұрын

Muchas gracias! excelente explicación!

@CurbalEN 7 жыл бұрын

+Norberto Vera Reatiga De nada Norberto :) /Ruth

@cuttell2000 3 жыл бұрын

Great video. Thanks

@zzzmd11 4 жыл бұрын

Hi Ruth, thanks for the great videos with great explanations, is very helpful all the time. I have a bit of an issue here. I have a dataset where I have a cumulative count. have 3 categories as country, state and city (which are also in the report). where I need to get the latest value of the count (max) and also when no item is selected need to show the sum of the maximum values....How can this be achieved...Please need help.Thank you so much in advance

@ogmino 5 жыл бұрын

I owe you a coffee! Nice job as always!

@CurbalEN 5 жыл бұрын

Let me know when you are Sweden ;) /Ruth

@MarkHinderliter 6 жыл бұрын

Hi Ruth, I used exactly the formula you included here for the cumulative by date, only my table and columns have different names. The underlying data is the same, and I don't get a running sum, it's the Total Tooling Sales measure duplicated. Here's my DAX: Running Sales = CALCULATE([Total Tooling Sales], FILTER(ALL(ToolingOrders[Date]), ToolingOrders[Date]

@DanielWeikert 6 жыл бұрын

Great work as always. I think I already asked but TODAY() and MAX(Date) is the same right? But is this always true?

@CurbalEN 6 жыл бұрын

HI Daniel, They are not the same. Today() will give you today's date while MAX(Date) will give you the last value on your date column. That is not always today's date :) Hope I explained myself! /Ruth

@kennethstephani692 Жыл бұрын

Great video!

@daveportland471 5 жыл бұрын

Hi Ruth , great video. I just came up with that one where running totals is worked out without ranking and summing up sales without dates: SUMX( FILTER( SUMMARIZE(ALLSELECTED(sales),sales[item],"TOTALSALES",[Sum Sales]), [TOTALSALES]>=CALCULATE([Sum Sales],VALUES(sales[item]))), [Sum Sales]) Here "Values" is essential inside calculate as it retrieves the initial filter context of the pivot , and get out of the summarized table filter context in order to compare the total sales of the summarized table and current sales of the pivot . I would appreciate your comment. Dave.

@CurbalEN 5 жыл бұрын

Awesome, thanks for sharing :) /Ruth

@nancmadi 4 жыл бұрын

@@CurbalEN I could not get his to work for me (posted on another KZfaq channel as well) but yours WORKED.. thank you!!!

@Technowolfopedia 6 жыл бұрын

Hi I have a question what would be a syntax I will have to use if i need to have a % of increase in volume month on month. I cant add a new column since I use a live connect. I have a Column with the volume and another Column with Month. So I need a see what is the percentage of increase or decrease in volume from previous month.

@CurbalEN 6 жыл бұрын

Can you please post this in the power bi community? Make sure you post some sample data! /Ruth

@christinelowery2415 10 ай бұрын

I love your videos. Dax Friday is great! I wonder how to calculate a cumulative sum of demand until it meets/exceeds inventory then it stops cumulative. It’s a challenge for me but maybe I am overthinking it

@wengyewlee1743 3 жыл бұрын

Excellent!

@suribhandari1985 2 жыл бұрын

Hello Mam - In which video you have clear the concept of Filter in your running total. Could you please share that link where in you spoke about 30 minutes.

@arjunjalan2007 2 жыл бұрын

Hi Ruth, Thank you for your videos. I am constantly referring in order to deliver quality dashboards at work! I notice a flaw in this logic: Referring tto 11:30 & 12:10. Row 3 & 4 are not actually getting added. Row 3 should be 41279 and row 4 should be 54914. Instead we have only one of those two values depending on your DAX formulae. The cumulative total doesn't seem to work in case of a tied rank. Am I missing something ??!

@CarlosEliezerHernandezPintor 3 жыл бұрын

Hi Ruth, how about to have different ranks even for same "sales" ? Otherwise I think we would have a longer pareto because we are not making a distinction between items with same sales.

@chaganti001 6 жыл бұрын

Thanks for sharing videos. it's helping me a lot. I have one scenario, please help me on that. The scenario is, where we have to show cumulative for distinct count of IDs on year -Month. And it should display for last 12 months, however count should be taken from beginning of the date and it will filter the data based on slicer or filters. Please let me know, if you need more details on it. Thanks very much in advance.

@CurbalEN 6 жыл бұрын

Post your case in the Power BI community so when it is resolved others can benefit from it too. Google does not index KZfaq comments. /Ruth

@dheerajmishra8765 4 жыл бұрын

Hi Ruth, I have one question about running total. I have used All and all selected functions for getting running total. I received the same result. Please explain me the difference between them.

@andru47 2 жыл бұрын

Hi Ruth and Curbal community. This is a great video that accomplishes the result with very few steps (I've seen others that make the calculation more cumbersome). I´m trying to complement the graph with a card visual that shows how many items represent < = 80% of sales, in the video for instance the value would be 4. I'm doing a calculation combining distinctcount with a filter (pareto % < = 0.8) but having trouble getting to the desired result on my report, any help will be welcomed and appreciated.

@sespitiap 7 жыл бұрын

Hola, excelente canal; casi todo me lo vi :) Tengo la siguiente pregunta. A partir de un cumplimiento (Ejecutado/Meta) que cambia de acuerdo al tiempo, debo calcular un color que esta parametrizado en otra tabla. El cumplimiento lo tengo en una medida (measure). ¿Como envió este cumplimiento (medida calculada) a cruzar con otra tabla (colores) para saber cual me debo traer?

@sespitiap 7 жыл бұрын

Lo e intentado de muchas maneras, como lograrlo desde PowerBi. Slds buen dia.

@CurbalEN 7 жыл бұрын

+Santiago Espitia Pinzon Hola Santiago, muchas gracias y me alegro que te gusten :) Podrías poner tu pregunta en la comunidad de Power Bi? Muchas gracias y buen fin de semana, /Ruth

@zxccxz164 6 жыл бұрын

i don't understand the cumulative when there are TIES. Its not truly doing a running total for each product, right? It groups all the ties together. Is that how it is supposed to work?

@CurbalEN 6 жыл бұрын

I forgot about ties when I did the video. You need to untie them: m.kzfaq.info/get/bejne/obikoMVpy9rdgZc.html&vl=en /Ruth

@jackie10111 3 жыл бұрын

In the running total using rank, I see two values in the with 3rd rank and for item No. 6 it does not add the previous total. How do we overcome this? can you please explain?

@geertvandenbroucke9223 3 жыл бұрын

Hi. You can use a calculated column instead: Rank = Rankx(tblsales,tblsales[Item],,1)

@pkfit8836 6 жыл бұрын

Ruth, One of my datasets only has month name and year. How can I get running total?

@CurbalEN 6 жыл бұрын

Post the question in the power bi community with some sample data :) /Rutg

@HeliezerGarcia01 7 жыл бұрын

Hello Rut, great videos. I have a question how don't stay number repeats, in percent ? Example Item 4 = 71% Item 6 = 71% Sorry my english, i don't speak very well !

@CurbalEN 7 жыл бұрын

+Heliezer Garcia Hi Heliezer, Could you please repeat the question? I speak also Spanish and Swedish if that helps! /Ruth

@CurbalEN 7 жыл бұрын

+Heliezer Garcia Hi again, Could be this what you are asking for? m.kzfaq.info/get/bejne/obikoMVpy9rdgQ.html /Ruth

@bsk1731 4 жыл бұрын

Hi thanks for video, have question on grouping.. what if we want to group these items based on % like Top 20% items into one group and remaining 80% into another bottom group, since if we have thousands of rows and grouping will good option.. how to do this, plz help

@CurbalEN 4 жыл бұрын

You will need to do that calculation first. Please contact the power bi community to get help and give them as many details as possible. /Ruth

@deepakverma7636 3 жыл бұрын

Hey Ruth, i noticed that running sales other has a wrong total when you are calculating it for items. How to correct it or else give the idea if i completely want to remove that grand total. Because in other viz i also facing the same situation where i dont need grand total but still it appears.

@geertvandenbroucke9223 3 жыл бұрын

To "remove" grand total in the visualisation, you can use field formatting (select the field - Font and background color: white - apply only to total) The grand total for the field will disappear.

@bethkulick92 5 жыл бұрын

I have been trying to download the example files for a few weeks now and it does not work?

@CurbalEN 5 жыл бұрын

Sorry to hear that, all download files have moved here: curbal.com/donwload-center /Ruth

@sanjayshukla3631 3 жыл бұрын

Hi Curbal - Big fan of your videos. Wanted to check if we can do opening balance and closing balance calculation for dataset having missing periods (months) which is very common when there are no stock movements? I tried using following calculations but these doesn't work when there are no stock movement for any period. Opening Balance = OPENINGBALANCEMONTH([RunningTotal_CBQ] , Inventory[PERIOD]) --Closing Balance Formula as RunningTotal RunningTotal_CBQ = CALCULATE(SUMX(Inventory , [Total_Qty]) ,FILTER(ALL(Inventory[PERIOD]) , Inventory[PERIOD]

@Amol51279 4 жыл бұрын

Hi Ruth, i wanted to create running totals for Current (2019) and Previous (2018) Years and show them in line chart with Short Month name. Cumulative Incident 2018 = CALCULATE([2018], Filter(ALLSELECTED(CalendarTable), CalendarTable[Date]

@Disaenz10 3 жыл бұрын

Ruth hi, how can I get the actual total from the "running sales other measure"?. It shows 14005 Thanks!

@franciscoclaudio4818 4 жыл бұрын

Congratulations on the class! But I have a problem: I need to classify 15 thousand products in A, B and C, based on a base with 15 million lines, and the way you passed is not possible. Is there any other way?

@CurbalEN 4 жыл бұрын

Do it in the source! Too much data. /Ruth

@franciscoclaudio4818 4 жыл бұрын

But the source will not be dynamic as I filter by the date ):

@sgk1966 7 жыл бұрын

Hi Ruth Thanks for the informative video. I feel if we cannot break the tie in the ranking, then the pareto chart will give the wrong line chart as the % will remain constant across categories having the same values. Since you are saying there is no way to break the tie in power BI, I feel it is better we don't create a pareto chart in powerBI

@CurbalEN 7 жыл бұрын

+Gopa Kumar Here is one way to break ties: m.kzfaq.info/get/bejne/obikoMVpy9rdgZc.html If you don't need a specific criteria for how you break the ties, it works! /Ruth

@sgk1966 7 жыл бұрын

Thank you. But can we use that measure in TOPN to get the cumulative total over each and every category? when I tried replacing the normal ranking with the normal ranking + rand in TOPN, the cumulative total is not giving the correct values.

@CurbalEN 7 жыл бұрын

+Gopa Kumar Havent tried that, so can't really tell. I will give it a go as soon as I have the time ! /Ruth

@sgk1966 7 жыл бұрын

No issues. Take your time. Just pointed it out. Thank you very much.

@CurbalEN 7 жыл бұрын

+Gopa Kumar Hi Gopa, thanks for your understanding. Time is something that I run out of all the time ! I can imagine it is the same for you ... /Ruth

@anjalimathe4314 4 жыл бұрын

Can you show how can I calculate %sales till a selected date wrt total sales made that month

@anam470 6 жыл бұрын

Hi Ruth, posted a comment on Curbal FB page. Could not attach the image in here. Please do check and reply. Thanks, Anam

@CurbalEN 6 жыл бұрын

+anam470 Hi Anam, I take a look at it and let you know :) /Ruth

@aniketroy4290 4 жыл бұрын

Hi! I am facing a problem, Running Sales is not coming as expected, it is just copying the SalesAmt Column. Others are coming just fine. Can you say what maybe the possible reason? Thanks!

@CurbalEN 4 жыл бұрын

It is either your relationships or your DAX. Post in the power bi community and give as many details as possible to get support! /Ruth

@rahulshiroor3739 4 жыл бұрын

Hi Mam.. I want to fileter here only 80% itmes. I dont want to show 20% and want to see upto 80% only, can u suggest me the measure for the same

@javiertriana1855 5 жыл бұрын

Hola Ruth. Tengo un problema con las sumas acumuladas y es que en lugar de fechas tengo un consecutivo. He probado la forma en que haces la suma acumulada probando con el Rankx pero lo que devuelve son "1" en todas las filas. Me puedes ayudar por favor....

@CurbalEN 5 жыл бұрын

Hola Javier, podrías poner la pregunta en la comunidad de power bi? Da todos los detalles que puedas para recibir ayuda rápidamente. Saludos! /Ruth

@javiertriana1855 5 жыл бұрын

@@CurbalEN Claro que si, me puedes indicar como hacerlo por favor.

@CurbalEN 5 жыл бұрын

Regístrate en community.powerbi.com y listo! /Ruth

@shoaibrehman9988 3 жыл бұрын

Hi Madam, I am watching fantastic full of information packages. But i stuck in one senerio can't find help. Would you please assist me. Suppose we have products A,B and C which are ordering in a month different days. I want running total of all product each month. Next month running start again means running total for each month not all 3 months. I want solution in DAX. I can calculate running total of 3 months but can't each month. Thanks in advance

@surender665 2 жыл бұрын

Hi please help me, how to calculate running total exclude current month

@sharavananp5570 3 жыл бұрын

What if two items have same value, rank gives 1,1, instead of 1,2. SO how does it work in this case

@dheerajmishra8765 4 жыл бұрын

Please make a video on shorting the month in chronological order in slicer in power bi

@CurbalEN 4 жыл бұрын

Check if this helps: m.kzfaq.info/get/bejne/eNRyZ9uGs8_Xg3U.html /Ruth

@dheerajmishra8765 4 жыл бұрын

@@CurbalEN This is working ruth Thanks a lot

@Wzxxx 2 жыл бұрын

Thank You, but I don't understand why we need ALL in the formula. There is already filter which makes a "subtable" for the sum (FILTER range of dates

@JorgeGrisman 6 жыл бұрын

Hello Ruth, I was able to create a calculated measure of running total sales using this formula: CALCULATE([Total sales with sumx], FILTER(ALL('MPSsales2012-2020'[Invoice Date].[Date]),'MPSsales2012-2020'[Invoice Date].[Date]

@nancmadi 4 жыл бұрын

Hi me again... so I built my report and everything worked awesome, however, I found my TOT_HELD Measure is not excluding my plants "Filter" TOT_HELD = SUM(NCM_Cost_of_Defects_UOM[Qty Held]) this measure shows all plants totals vs 'Filtered'... But the Measure H_CUMM is excluding plants correctly "Filter"... I notice my CUMM was lower (correct #) then then if you added the # in the TOT_HELD manually its higher. H_CUMM = CALCULATE([TOT_HELD],TOPN([H_RANK],ALL(NCM_Cost_of_Defects_UOM[Defect Type]),[TOT_HELD])) How do I make my first measure take into account for the filtered plants and show the correct #? Thank you!!

@CurbalEN 4 жыл бұрын

Uhh, mmmm that is a question for the power Bi community. Make sure you share sample data and your model to get proper help! /Ruth

@nancmadi 4 жыл бұрын

@@CurbalEN Thank you Ruth....

@Darokbr 3 жыл бұрын

Hi Curbal, these formulas doesnt work on large datasets. Power Bi doesnt calculate at all. 300k lines ++

@akashragi2347 7 жыл бұрын

can i know how to calculate average of sales for every year?

@CurbalEN 7 жыл бұрын

+akash ragi Hi Akash, without any details, it is difficult to answer your question. My recommendation is to post your query in the power bi community following this guidelines: community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 /Ruth

@kummithavenkatareddy2302 2 жыл бұрын

Pls do a video on Pareto chart Requirement: we have 2300 customers whose whose sales Loss/Profit vary from -2500000 to 4500000 USD in a FY in a company. I want to show bottom most customers contributes to the business by using Pareto Chart. Pls explain.

@anjutamang2542 5 жыл бұрын

I tried to calculate cumulative totals by using earlier but it didn't work. I can't find my errors.

@CurbalEN 5 жыл бұрын

Did you use a calculated column? /Ruth

@daniel.balandra 5 жыл бұрын

@@CurbalEN Hi Ruth, so "earlier" function only works for calculated columns, it gives de current row in order to compare. But for measures, "Max" function works the same as "earlier"? It shoudnt give the highest date of all date showed in the table? Please could you go a little bit through this? Thnaks in advance, and BTW, which is the link to the PBI community? Best regards

@CurbalEN 5 жыл бұрын

Hi Daniel, Yes, MAX can be used instead of EARLIER depending on what you are trying to do. I will definitely do more videos on the topic in the future. The link to the Power BI community is community.powerbi.com /Ruth

7 жыл бұрын

Lo logre! wujuuu :D

@CurbalEN 7 жыл бұрын

Genial!! Me alegra mucho! Ya nos ensenaras tu informe en la comunidad! /Ruth

7 жыл бұрын

Si! lo voy a compartir siguiendo tu consejo, gracias!

@CurbalEN 7 жыл бұрын

+José Rafael Escalante Genial!

@franciscoclaudio4818 4 жыл бұрын

When I try this with a base with 9 thousand products it doesn't run.

@jalonjalon145 2 жыл бұрын

Isnt the total of running sales wrong ?! or am i missing something here?!

@vimukthiamarasena6264 3 жыл бұрын

Hi can you give me a hint to calculate the Running total with duplicate dates. (example: when there are many orders per one day) Date Order Order Qty running Total 11/17/2020 A 5 5 11/17/2020 B 10 15 11/17/2020 C 4 19

@geertvandenbroucke9223 3 жыл бұрын

Hi. First add a calculated column: Rank = rankx(tblorders,tblorders[Order],,1) Then use a measure: Running total = CALCULATE(sum(tblorders[Order Qty]),filter(all(tblorders),tblorders[Rank]

@kusalamarasena3882 3 жыл бұрын

@@geertvandenbroucke9223 thanks Geert

@alfredoaraizaespinosa5017 3 жыл бұрын

Ruth muchas gracias a donde te mando un cafe !!!!

@alfredoaraizaespinosa5017 3 жыл бұрын

sabes como puedo usar el Pareto % as slicer? =/

@gaid81 6 жыл бұрын

Dear Rut thanks for videos , seeking your support to calculate MOC based on STK of Previous Month - [TOT FCT] current month+ [TOT Purch ] current month + [previous month closing STK] come from the same measure I need the result to be used in next month for same measure I have dimension separate date table your support is highly appreciatedThanks

@CurbalEN 6 жыл бұрын

Hi +AHMAD GAID, Could you please post this question in the Power BI Community? community.powerbi.com When you get an answer, the solution will be then indexed by google and others can also benefit from it. Thanks! /Ruth

@gaid81 6 жыл бұрын

Sure Ruth , appreciated , Regards Ahmad

@feng3625 5 жыл бұрын

why the Total % is 18%. it doesn't make sense to me

@CurbalEN 5 жыл бұрын

I did that video a while ago, could it be this the problem? kzfaq.info/get/bejne/q8x4grJ9yc_Dmp8.html&vl=en /Ruth

@MRR838 3 жыл бұрын

How to get every month 15 Date & After 15 to Month-end Dates cummulative Sales

@LotfiORouis Жыл бұрын

Why don't you show how the [Sum Sales] measure was calculated ?? 😔

@user-tp3tf5hv6s 4 жыл бұрын

Спс. Очень доходчиво 🙄

@CurbalEN 4 жыл бұрын

пожалуйста 😁

@marimendes7297 4 жыл бұрын

Я не поняла что ты сказал

@CurbalEN 4 жыл бұрын

я тоже

@marimendes7297 4 жыл бұрын

@@CurbalEN kkkkkkkkkkkkkkk

@marimendes7297 4 жыл бұрын

@@CurbalEN I love you, thanks to your videos I'm learning a lot about DAX, thank you very much, I'm Brazilian and I found your channel because of Karine Lago, thank you for your videos