Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Create two different fields from single table with one date

Hello all!   I need to use one table, with one Created Date and output two different fields from that. Basically, a user can choose one date timeframe and the output would be called "Branded". Then...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , 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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

HI amitchandak ! I did create those fields, but how do i create the BRANDED and UNBRANDED to show on the same table chart, one for each line? Like this???