Show data for latest 30 days when report opens

[Anonymous]

Hi All,

Do anyone has any idea of - How to show data for latest 30 days of refresh date when user opens the report intially. "Relative data doesn't work for my requirment( as refresh dates doesn't concrete with system dates)". so please do not think abt relative date option

[sanimesa]

@AnonymousSo you do not actually want to show data for the most recent 30 day interval but for 30 instances of data points, is this  correct?

Option 1. Assuming you have an actual date column in data, you can create measure that will calculate a sequence number for each date.

Option 2. Create a view with an auto increment column which will contain a running refresh count.

Then you will simply create a filter where you select the last 30 values of this sequence or count. This is all I can think of without looking at the data.

[Anonymous]

@sanimesa ,

Can you give more info on 2 options provided. How to achieve those?

[amitchandak]

@Anonymous ,

Try like

Is last 30 = if('Date'[Date]>=TODAY()-30,"Last 30 Day","Before last 30 Day")

Use this a the filter

Appreciate your Kudos.

https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184

[Greg_Deckler]

Well, generally the way people do this is to create a column in their table that is something like:

Column = (TODAY() - [Date]) * 1.

Then they set some filter to be < 30 for this column. But I don't understand system dates versus refresh dates so you would have to explain that.

[Anonymous]

@Greg_Deckler 

Let me know where do they set the filter like <30 in report?

[Anonymous]

@Greg_Deckler 

Actually, My project is migration from Mainframe to Power BI. So my refresh dates will be the date at which report is taken from Mainframe server and few reports may be daily frequency, weekly, monthly, yearly..

So my Refresh dates are random

[Greg_Deckler]

So, same basic concept but use

Column = MAX([Date]) - [Date]

?

You need to define what you mean by last 30 days. I don't understand that refresh dates are random.