Forum Discussion

bsheffer's avatar
bsheffer
Continued Contributor
6 years ago
Solved

replace calculated column with measure

I need to re-bin a calculated column ("1-10" combined with "11-20" to becomes "1-20" and so forth but since I'm connected to a published dataset I cannot create a new calculated column, just measures...
Need Help
Tutorial Requests
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi bsheffer ,

     

    'Column series' label can not add a measure, so you need to remodel in the original dataset, and then reconnect this dataset in the new .pbix file.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

Share some data and show the expected result.

  • bsheffer's avatar
    bsheffer
    Continued Contributor
    6 years ago

    type, account, date_opened, age_of_account

    house, 11, 2020-01-01, "1-30 days" -> less than 70 days

    business, 12, 2020-01-30, "1-30 days" -> less than 70 days

    house, 13, 2020-03-05, "60-70 days" -> less than 70 days

    house, 14, 2020-05-05, > "than 70 days" -> more than 70 days

     

    age_of_account is the calculated bin column

    want to change the bins as listed

    and then want to put into line and stacked column chart with

     

    month(date_opened) as the shared axis

    age_of_account as the column series

    count of accounts as the column values

     

    however it isn't letting me put the measure in the column series position.

    I don't have the option to create a table or a calculated column

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      6 years ago

      Hi,

      I really do not understand.  Share data in a format that can be pasted in an MS Excel workbook.  Also, show the expected result clearly in a Table format.

    • v-lionel-msft's avatar
      v-lionel-msft
      Community Support
      6 years ago

      Hi bsheffer ,

       

      'Column series' label can not add a measure, so you need to remodel in the original dataset, and then reconnect this dataset in the new .pbix file.

       

      Best regards,
      Lionel Chen

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.