Forum Discussion
Sander_NL
Helper I
Helper INeed help multiple rows of data into one unique table and calculation last 30 days
Hi, I have 2 tables: 1) List of servers that should be backed up (CMDB table) 2) I have a dataset from an API call. This contains multiple lines of data to determine whether a backup has been s...
Last Completed_Backup = CALCULATE ( MAX ( Blad1[Backup schedule] ), Blad1[Status] = "Completed" )
Number of completed backups = VAR result=CALCULATE(COUNTROWS(Blad1),Blad1[Status]="Completed") RETURN IF(ISBLANK(result),0,result)
Zubair_Muhammad Thank you very much for your quick response. This solution is everything I need.
Zubair_Muhammad
Community Champion
Community ChampionHI Sander_NL
First create a relationship between your tables using the common Field i.e. Servers Field
Now you can use these calculated columns
Date last backup = CALCULATE ( MAX ( Blad1[Backup schedule] ) )
Status Last Backup =
VAR Result =
CALCULATE (
FIRSTNONBLANK ( Blad1[Status], 1 ),
LASTDATE ( Blad1[Backup schedule] )
)
RETURN
IF ( ISBLANK ( Result ), "Not Found", Result )
- Zubair_Muhammad
Last Completed_Backup = CALCULATE ( MAX ( Blad1[Backup schedule] ), Blad1[Status] = "Completed" )
Number of completed backups = VAR result=CALCULATE(COUNTROWS(Blad1),Blad1[Status]="Completed") RETURN IF(ISBLANK(result),0,result)
- Zubair_Muhammad
Sander_NLZubair_Muhammad Thank you very much for your quick response. This solution is everything I need.