Forum Discussion
Create two different fields from single table with one date
Kornholio1313 , For this the slicer needs to be on independent date table
//Date1 is independent Date table
Branded =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = minx(allselected(Date1),Date1[Date])
return
calculate( sum(Table[Value]), filter('Table', 'Table'[Date] >=_min && 'Table'[Date] <=_max))
//Date1 is independent Date table
Not Branded =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = minx(allselected(Date1),Date1[Date])
return
calculate( sum(Table[Value]), filter('Table', 'Table'[Date] < _min && 'Table'[Date] > _max))
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
ThanksAmit!, So, I created two tables with the same data. I want to show two calendar filters, one for the chosen "Branded" between dates and the other filter with the "UnBranded" between dates. Can i show this in one table format like this then?
If you need branded and unbranded as rows, You need create measures for
UnBranded records, UnBranded Engaged , UnBranded diff
Branded records, Branded Engaged , Branded diff
As suggested above and then use calculation group to create the desired output.
Remember, you need a column, but calculated column can not take slicer value, so you have to go measure way
Check the option, where I have split the Calculation group using a custom column
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Thanks, I still didnt get the results I needed, maybe just something that PBI cant do. Oh well back to using Tableau again. I really wanted to show that PBI could do this better than Tableau, but in this case, I guess not.