Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Simplifed version of the situation, - say I have 2 views:
Those go into a Data Model, which I'll connect to via Live Connection. When doing a live connection, one can't add calculated columns.
I effectively need to add the calculated column that is in the below image, in blue, so that I can run numbers on that MonthsFromStateDate column. My sweet blue arrow shows the columns that are used for the calculation.
I actually control the underlying views / data model, so:
So question: Calculated column in this case, or can you think of an equally good way to do this without creating a calculated column?
Solved! Go to Solution.
I think in your case, it's better you create that column in your underlying view, will be more efficient.
However there is always a way, you can think on below:
1). Lets assume you will have 20 unique 'MonthsfromStateDate' values, so create or have a separate table, having just one column 1 to 20.
2). Now you will create a measure, either you can use switch and define for each 'MonthsfromStateDate' or think about any other logic.
So in chart, now you can now drag the column from above point 1) table in the axis.
Hope above is making sense.
I think in your case, it's better you create that column in your underlying view, will be more efficient.
However there is always a way, you can think on below:
1). Lets assume you will have 20 unique 'MonthsfromStateDate' values, so create or have a separate table, having just one column 1 to 20.
2). Now you will create a measure, either you can use switch and define for each 'MonthsfromStateDate' or think about any other logic.
So in chart, now you can now drag the column from above point 1) table in the axis.
Hope above is making sense.
Thanks, If I created a 'MonthsFromStartDate' table - it wouldn't have any way to connect to the TransactionsFACT table, unelss I had a calculated column there. So sorry I don't follow - how could I use that 'MonthsFromStartDate' table in the axis and have it work?
Hi @mmace1 ,
You can create a measure to connect the 2 tables,it would be easier to explain if you could upload your .pbix file to onedrive business and share the link with us?
Remember to remove the confidential information.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |