Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Last Date for Distinct User and Item Modified

Hello all,   I have a table with columns "Task Modified By", Task Modified On", "Activity Modified By", "Activity Modified On","Process Modified By" and "Process Modified On". The "...By" columns a...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    Hello Anonymous 

    My first thought is to split the items into 3 tables, tag them with their type and stack them.

     

    Then you just use the stacked table and a couple measures.

    I have attached my sample file for you to look at.

     

    If this solves your issues please mark it as the solution. Kudos 👍 are nice too.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

Here's a solution without creating 3 Tables.  You may download my PBI file from here.

Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello Ashish_Mathur

 

I cannot download the .pbix due to my organization restricting the source. Could you please upload it to the forum like the other responder did above?

 

Thank you,

Bogdan