Forum Discussion
MdxScript(Model) (27, 88) Calculation Error in measure
The solution to this was that I had a date filter going in both directions from my date table to my date fact table. I changed this to one way.
The reason I had to have a date fact table is because there were multiple companies in my date table with their own fiscal year calendars.
Thanks for your replies, they help me ascertain what the problem was and reconfirmed that I was doing the right thing in regards to the time intelligence piece. Also, note, I had encountered another issue when dealing with tabular modelling when dealing with the date hierarchy's...SSAS passed them through to Power BI as text!
The solution to this was that I had a date filter going in both directions from my date table to my date fact table. I changed this to one way.
The reason I had to have a date fact table is because there were multiple companies in my date table with their own fiscal year calendars.
Thanks for your replies, they help me ascertain what the problem was and reconfirmed that I was doing the right thing in regards to the time intelligence piece. Also, note, I had encountered another issue when dealing with tabular modelling when dealing with the date hierarchy's...SSAS passed them through to Power BI as text!