0

I'm trying to build a Power BI file from a SSAS Cube and we need to have a last modified date based on the last call logged on a table. I'm new to MDX and already tried to use MAX() and that just returns null.

Thanks, Sam

jarlh
  • 42,561
  • 8
  • 45
  • 63
Sam Deason
  • 1
  • 2

2 Answers2

0

Something like below might help you:

enter image description here

sacse
  • 3,634
  • 2
  • 15
  • 24
  • I've tried Max([Fact Phone Data].[Call Date].Members, [Fact Phone Data].[Call Date].currentmember.Member_Key), but the date is in the last month(9/9/2018) and I've data up until (10/20/2018 – Sam Deason Oct 24 '18 at 19:24
  • Is the only way to get a max date value by using a integer date field? – Sam Deason Oct 30 '18 at 12:55
  • No, when the dates are stored as integers, they serve the purpose of a key as well as the value. – sacse Oct 30 '18 at 15:58
  • Would you by chance to know how to get a max date based on a date type? – Sam Deason Oct 31 '18 at 17:52
  • The following link might help you https://stackoverflow.com/questions/18598669/mdx-ssas-max-date-in-measure – sacse Oct 31 '18 at 21:41
0

Instead of using a calculated member, use a measure with the max function and it will correctly show the last date.

Sam Deason
  • 1
  • 2