In the column, I added Name column of the Calculation Group.Total Sales & Units measures added to my Pivot Table.I revise my Pivot Table with the following changes Note that I used the same DAX expression but just replaced with SELECTEDMEASURE () to allow this calculation to run on any or all measures displayed in the visual. Then let’s create a New Calculation Group.If you have installed it, you’ll see it in the External Tools ribbon. This problem can be solved with the 2nd Approach – Calculation GroupsĬalculation Groups to Switch Between Current Period and YTD CalculationĬalculation Groups are possible in Tabular Editor. This approach is not dynamic to work on any measure placed in the Pivot Table. The only problem with this approach is that if I’d like to do the same with, then I need a new measure with the same DAX which replaces with. If you place this measure in the pivot table, it works beautifully! In case you are curious, here is the link to understand the SELECTEDVALUE Function SELECTEDVALUE(SelectionTable) = "YTD", TOTALYTD(,'Calendar'),
SELECTEDVALUE(SelectionTable) = "Current Period", , I write this simple Switch Function to toggle between Current Period Sales and YTD Sales. I am going to create this Selection Table and make a slicer on Value Column.Īs of now selecting the slicer does nothing, so let’s create a measure to reflect the calculation selected.Ĭreating a Measure to Switch between Current Period and YTD Sales My Need – I’d like to have a slicer to pick between Current Period Sales or YTD Sales and the Pivot Table should then display the results accordingly. Why don’t we start with Approach 1 – Using Plain Vanilla DAXĪ simple Pivot Table with Year and Month and Total Sales
#TUBEDIGGER VS YTD HOW TO#
Essentially this is an offshoot of the blog that I wrote a while ago on how to change measures with a Slicer but I’d like to add an approach using Calculation Groups that makes this Calculation Dynamic.
"You haven't wished a new year yet" = TRUE (), - Rule2Īnd I do hope that you do a lot more interesting things this year than reading my poor jokes 😀Īnd to begin an interesting topic, I’d like to talk about how can you switch between a Current Period and YTD Calculation with a slicer. Although it’s a bit late but I follow 2 rules.
0 kommentar(er)
