Forum Discussion

KBO's avatar
KBO
Memorable Member
7 years ago

Last Status based on Date/ Time

Hello together, I have a question is there a DAX formula with which you can calculate the last status? So I have a computer with several packages installed, sometimes not successfully. Now I would ...
Need Help
KBO's avatar
KBO
Memorable Member
7 years ago

I tried out this solution but I get an error message:

 

MyValues Column = SUMMARIZE(VIEW_REPO_ARCHIVEDISTJOBS;VIEW_REPO_ARCHIVEDISTJOBS[COMPUTERNAME];
"LastDate"; Max(VIEW_REPO_ARCHIVEDISTJOBS[LASTMODTIME]);
"ItemCount"; CALCULATE((Max(VIEW_REPO_ARCHIVEDISTJOBS[RESULT]));
Filter(VIEW_REPO_ARCHIVEDISTJOBS; VIEW_REPO_ARCHIVEDISTJOBS[LASTMODTIME] = Max(VIEW_REPO_ARCHIVEDISTJOBS[LASTMODTIME]))))

 

The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

 

Where is my mistake in thinking?

 

Best Kathrin

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Hi KBO,

 

You should create a calculate column, not a calculate table. If still can't meey your requirement, could you share some sample data and clarify more details about your logic and expected result?

 

Regards,

Jimmy Tao

  • KBO's avatar
    KBO
    Memorable Member
    7 years ago

    If you like v-yuta-msft I can send you a dummy-data file? I don't see how I can attached a file to my post. 

     

    Best Kathrin

    • v-yuta-msft's avatar
      v-yuta-msft
      Community Support
      7 years ago

      Hi KBO,

       

      You can upload your sample file to some cloud storage(e.g.: microsoft onedrive or google cloud storage) if possible.

       

      Regards,

      Jimmy Tao