Problems with PivotTable Running Totals and HOW TO FIX THEM - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
itech
Hi Mynda, this running total measure DAX is really helpful. But how could I create a measure to calculate the difference of two consecutive rows in a power pivot table, say next row-s value minus current one? (My case is - my data table has records only when the plant generates data, thus the date or time is not continuous, or I will have some empty row if I use my calendar table to summarise data, as far as I know I cannot use DAX function like PREVIOUSDAY, EARLIER, etc). I am still not familiar with DAX functions, so could you make an episode to address the above mentioned issue for calculating difference of two role in a power pivot table by using DAX function. Thanks!
reply
Hi Mynda, this running total measure DAX is really helpful. But how could I create a measure to calculate the difference of two consecutive rows in a power pivot table, say next row-s value minus current one? (My case is - my data table has records only when the plant generates data, thus the date or time is not continuous, or I will have some empty row if I use my calendar table to summarise data, as far as I know I cannot use DAX function like PREVIOUSDAY, EARLIER, etc). I am still not familiar with DAX functions, so could you make an episode to address the above mentioned issue for calculating difference of two role in a power pivot table by using DAX function. Thanks!
reply
Mesut
Hi Mynda
Great video!
I've searched around a bit now and only find examples similar to yours. I have a problem to run totals by date and product. I've tried to combine different DAX formulas but the runing totals with DAX only work when I exclude product. I would really appreciate and hope other will to it too if you can guide or help me.
Example: In the end of your demonstration you made in the pivottable you,
dragged and drop dates to -row-
and dragged and drop measures to -Values- field
How about when you drag and drop anydata (for.eg products) to -columns-
Best Regards
reply
Hi Mynda
Great video!
I've searched around a bit now and only find examples similar to yours. I have a problem to run totals by date and product. I've tried to combine different DAX formulas but the runing totals with DAX only work when I exclude product. I would really appreciate and hope other will to it too if you can guide or help me.
Example: In the end of your demonstration you made in the pivottable you,
dragged and drop dates to -row-
and dragged and drop measures to -Values- field
How about when you drag and drop anydata (for.eg products) to -columns-
Best Regards
reply
John
You-re the best I-ve came across btw.
Explanations, definitions, professional terse intro with oblivious depth and passion is how I like it. Your dashboard training pretty much catapulted my career.
My running totals stop at month ends, then rests every month. My lookup date column is week ending dates only. I wonder if that-s why.
John
Texas
reply
You-re the best I-ve came across btw.
Explanations, definitions, professional terse intro with oblivious depth and passion is how I like it. Your dashboard training pretty much catapulted my career.
My running totals stop at month ends, then rests every month. My lookup date column is week ending dates only. I wonder if that-s why.
John
Texas
reply
Vincent
Hi Mynda, When using this formula for a measure on a data set that is really long (160k+ rows) it takes a very long time to load. Is there a more complex formula/filter I can apply to make sure it is not looking at all of the data (every row) to make the chart/table? Currently it take 3 minutes to make the chart.
reply
Hi Mynda, When using this formula for a measure on a data set that is really long (160k+ rows) it takes a very long time to load. Is there a more complex formula/filter I can apply to make sure it is not looking at all of the data (every row) to make the chart/table? Currently it take 3 minutes to make the chart.
reply
George
Great video! If there are two dates in the table i.e. Order date and shipped date, thus making one active and one inactive relationship, how can we get the RT result? Where do we place the USERELATIONSHIP formula? Thanks in advance!
reply
Great video! If there are two dates in the table i.e. Order date and shipped date, thus making one active and one inactive relationship, how can we get the RT result? Where do we place the USERELATIONSHIP formula? Thanks in advance!
reply
Jason
Thank you! In your example, what if you have forecast in 2022 but no actuals. How do you show zero for actuals RT in 2022 instead of repeating 301,845 . I would like to show where the RT stops in a year and not repeat the values.
reply
Thank you! In your example, what if you have forecast in 2022 but no actuals. How do you show zero for actuals RT in 2022 instead of repeating 301,845 . I would like to show where the RT stops in a year and not repeat the values.
reply
Hardik
I-ve seen many masters in excel-but you are outstanding. You are doing with so confidently, we have to pause the video to understand.
Curious to know how long you are using this excel ?
reply
I-ve seen many masters in excel-but you are outstanding. You are doing with so confidently, we have to pause the video to understand.
Curious to know how long you are using this excel ?
reply
redpoo
Hi Mynda, how did you get the option for Actual(Date)? I assume that's referring to an Actual column in the date table? When I create a date table it doesn't add data columns into it.
reply
Hi Mynda, how did you get the option for Actual(Date)? I assume that's referring to an Actual column in the date table? When I create a date table it doesn't add data columns into it.
reply
Jarrod
Thanks for the great video. Does this work the same way when we want the running total along the bottom rather than down the side?
reply
Thanks for the great video. Does this work the same way when we want the running total along the bottom rather than down the side?
reply
ali
What should we do if we want the pivot table show the value not sum or mean or any other modifications on the values of each row?
reply
What should we do if we want the pivot table show the value not sum or mean or any other modifications on the values of each row?
reply
Add a review, comment
Other channel videos
4:14
