Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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,
Solved! Go to 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
"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?
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
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
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
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
"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?
User | Count |
---|---|
120 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
166 | |
82 | |
68 | |
65 | |
53 |