Roll over to new month after first non-blank day occurs in new month, otherwise show previous month.

[CRamirez]

I have a daily dashboard that displays current month information. It borrows visuals from about 6 different reports, some with varying refresh periods (live vs. daily). The visuals that are tied to once-daily refreshed reports always appear blank on the first day of a new month. This is due to the reports utilizing "is in this month" relative date filtering.

These visuals will not get data for the current month until the next day so I would like to display the previous month's data until the data for the new month is loaded. In addition, once I have data for the new (current) month, I would then like for the previous month to disappear.

I attempted using a variation of DATESBETWEEN and LASTNONBLANK, but the measure was returning a cumulative total for the previous month. I need it to only display daily data and not SUM multiple days together.

To give you an idea of my data structure, I have a date table connected to a singular fact table that contains inventory information daily.

Any help on this problem would be much appreciated

[v-yulgu-msft]

Hi @CRamirez,

If you want to dynamically display data in current month and previous month based on a specific scenario, per my knowledge, you have to use measure. But, the values wrapped in a measure have to be aggregated with functions like SUM, MAX, etc. If you just use a table visual to display meta data (without any aggregation, just original fields) from dataset, it is not possible to achieve the requirement that show previous month's data on first day of month while display current month's data when new data is loaded.

Regards,

Yuliana Gu