Combining tables with latest data || user inactivity reporting in M365 & Okta

[Anonymous]

Hi I have two Tables, one from Okta and one from M365.  Both tables include username, lastlogin and created dates.  I want to report the latest "login" activity from the two tables etc.

So far i have created a new Table called Users, and created a link between the two Username columns from the Okta and M365 tables.

I also created some measures to get the Max lastlogin date from each table for each user (i think), using this query.

LatestSignin =
MAX (
    CALCULATE ( MAX ( M365[LastLoginDate] ) ),
    CALCULATE ( MAX ( Okta[LastLoginDate] ) )
)

I obvisouly also tried created a SigninDateTable, but that seems to be based on either M365 or Okta, rather then both??

With all of the above, in its current state, i can drag in Username and LatestSignin from the Users table, into a Table Visual and it appears to work fine, but i cannot use the LatestSignin measure in a Bar chart or any other visual.

In general i am trying to say "Get all the data from both M365 and Okta Tables, marry it together, then give me the latest dates, so that i can use them in vusuals and more importantly, report on my active & inactive users."

Is my model all wrong at a fundamental level, or am i just missing something still?

[parry2k]

@Anonymous measures cannot be used on the x-axis

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[parry2k · Accepted solution]

@Anonymous your model is correct and you are on a right track. You cannot visualize dates as values on the bar chart, only numeric values can be visualized on the bar charts. What do you want to visualize on the bar chart once you have LastSignIn information?

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[Anonymous]

Hi 👋 

with the LastSignin measure, I assume it's a Date data type, so why wouldn't I be able to use it on the X axis for a histogram time based visual.  

I'd like to show last signing date in a time based bar chart