Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

(Another) Sort by another column problem

Trying to sort a column in my custom date table (a csv file) via a calculated column in the same table but am seeing an error. The calculated column does not reference the column I wish to sort by. H...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I believe I've solved this problem. It was caused by a relationship between my date table and a fact table. The relationship was between a calculated column in the latter that looked up a value from a column in the former. Power BI allowed it, but it seemed to affect the behaviour of reports built using the dataset.

     

    Removing the relationship means I can perform the sort I need.

     

    To recreate the relationship, I've calculated a table in the query that include only the columns I need and inserted this between to the two tables in my model.

ChrisMendoza's avatar
ChrisMendoza
Resident Rockstar
6 years ago

Anonymous -

What is the error you received?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

     

    • ChrisMendoza's avatar
      ChrisMendoza
      Resident Rockstar
      6 years ago

      Anonymous -

      You've identified this table as a 'Mark as Date Table' correct? Can you provide a sample?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        No, I haven't marked it as a date table. I don't need to use the time intelligence fucntions as my calendar has custom periods.  I'd be happy to provide the csv but I don't have anywhere I can upload it that I can access as work.