Help

[Syndicate_Admin]

Good afternoon, I have to make a Dashboard where it shows who is turning years today and how many years he meets,

the table I have connected to directquery from sql is :

ID Name Birthday

1 Andrew 2/9/1990

2 Jose 2/7/1995

I need to create a card where it shows me who meets today, but I could not be able to do it,

I thank you for your help as professionals.

Best regards

[v-yalanwu-msft · Accepted solution]

Hi, @Syndicate_Admin @;

If I understand right, you could create two measure as follows:

Namemet = CALCULATE(MAX([Name]),FILTER('Table',MONTH([Birthday])=MONTH(TODAY())&&DAY([Birthday])=DAY(TODAY())))

Year = IF([Namemet]<>BLANK(),DATEDIFF(MAX([Birthday]),TODAY(),YEAR))

The final output is shown below:

If there's more than one person who meets the criteria, then card doesn't work, you can use a table. If I don't understand correctly, can you share the simple file and the result you want to output?

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.