How to control expression output by checking Todays date vs another date?

[jblomqvist]

Hi,

I want to control a information shown in a gauge based on today's date against a date table.

Example:

Show Dec 2017/18 data only after the PublishDate of 19/02/2018 is reached.

Or in other words, If Today's date is less than or equal to 19/02/2018 then show Nov 2017/18 data, otherwise show Dec 2017/18 data.

My PublishDate resides in a table like this:

MonthYear	PublishDate
Nov 2017/18	14/01/2018
Dec 2017/18	19/02/2018
Jan 2017/18	11/03/2018
Feb 2017/18	15/04/2018
Mar 2017/18	18/05/2018

Does anyone know how to include this inside an aggregation such as count or sum? It is Set Analaysis I think but am a little stuck on how to wrtie it.

This is a gauge so I have no dimensions, have to do this inside my aggregation expression.

[sunny_talwar]

But where exactly is your data? All you have shared is what the PublishData look like, but how is this connected to everything else in your dashboard. Would you be able to share a sample to show more?