Forum Discussion

Kornholio1313's avatar
Kornholio1313
Frequent Visitor
2 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
Kornholio1313's avatar
Kornholio1313
Frequent Visitor
2 years ago

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?

 

amitchandak's avatar
amitchandak
Super User
2 years ago

Kornholio1313 ,

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

  • Kornholio1313's avatar
    Kornholio1313
    Frequent Visitor
    2 years ago

    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.