Last Status based on Date/ Time

Question

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 like to know if all packages on the computer have passed successfully, based on the last date/time. Is that possible?It should serve the overview which computers are not yet completely finished. (Like monitoring view)&nbsp;Best Kathrin

kbo · Answer

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 · Answer

Hi KBO,
&nbsp;
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?
&nbsp;
Regards,
Jimmy Tao

kbo · Answer

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

v-yuta-msft · Answer

Hi KBO,
&nbsp;
You can upload your sample file to some cloud storage(e.g.: microsoft onedrive or google cloud storage) if possible.
&nbsp;
Regards,
Jimmy Tao

ryan_mayu · Answer

Hi KBO,&nbsp;You can use group by function. Hope this can help you.&nbsp;

Forum Discussion

Last Status based on Date/ Time

6 Replies

Related content

Dynamic Status Change for events based on selected date range

Dynamic Filtering based on date selection

Client Status Measure Based on Selected Date

Conditional format date based on another date

Values not averaging correctly based on date