Forum Discussion
Kornholio1313
2 years agoFrequent Visitor
Create two different fields from single table with one date
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 the user can c...
amitchandak
Super User
2 years agoKornholio1313 , 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