Add Dynamic Date Cards in Power Bi report

[DryMouse555]

Hello all,

I am getting three months of data into power BI. I have not specified the exact month in the source, it just pics the start date as first day of current month and End date is calculated based on the start date (start date -3 months). I can see the data fine in power bi.

In the report, I want that three months related values like below. Current month is April.

Jan	$500
Feb	$600
March	$700

In May when I refresh the dataset, I should automatically see

Feb	$500
March	$600
April	$700

How can I do that withoout specifying months in the filter panel.

Thanks,

[Ritaf1983 · Accepted solution]

Hi @DryMouse555 
You can use a related date filter :

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

[v-tangjie-msft]

Hi @DryMouse555 ,

Whether the advice given by @Ritaf1983   has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Best Regards,

Neeko Tang

[DryMouse555]

what if I write a calculated column with below logic. 
if current month, then take current month -1 (gives me the last month ex: June)
if current month, then exclude current month -1 and take current month -2 (skips last month (June), and gives me the last before month (May))
If yes, how to write this logic?

or can you suggest a better way

[Ritaf1983 · Accepted solution]

Hi @DryMouse555 
You can use a related date filter :

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

[DryMouse555]

Hi, 

But, with relative date, I can do last 1 month (will get last month only), but if I want to get before that month, how can i do in relative date? it does not have option to skip last 1 month and get the month before that

[Ritaf1983 · Accepted solution]

"calendar month" is a full month.
So it will filter the data for 3 full months...

For example today it will give June, May, and April...

This is not what you need?

@DryMouse555