Report Subscriptions

[s_mccafferty]

Hi all

I have a report subscription which currently runs daily.  The report is based on comparing a date from a dataset against todays date, if dataset date equals todays date, then the record appears in the report.

On some occasions there will be no match, is it possible to prevent the report being issued when the report is blank?

[v-yuta-msft · Accepted solution]

@s_mccafferty ,

You can create a calculate column using DAX below and build a slicer based the calculate column then select "Yes".

If_Match = IF('Table'[Date] = TODAY(), "Yes", "No")

 

Community Support Team _ Jimmy Tao

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