Check data delivery still up-to-date

[Anonymous]

I'm trying to build alerts for our dataflows. I've build a tableprofile() in PowerQuery and need to see if the MAX of 1 of the columns is not to old. 

For this I'm trying to write a DAX code that when the date is below a certain threshold (e.g. a week old) it will show. So far I've haven't gotten very far. Hopefully someone knows a solution for this?

[selimovd]

Hey @Anonymous ,

if you want to get the MAX from a column use:

Max Column = MAX( myTable[myColumn] )

Otherwise please provide an example, what the result is and what you would expect. That makes it easier to help you with your issue.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

[Anonymous]

I've added an image of the Dashboard. The KPI only gives the date but you cannot give it a date a value for an alert. 

[v-chenwuz-msft · Accepted solution]

Hi @Anonymous ,

alerts = 

VAR _TODAY = TODAY()

VAR _MAX = MAX(Table[date])

Return

VALUE(_TODAY - _MAX)

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

This solution worked, thank you