Forum Discussion
Solved
Add Dynamic Date Cards in Power Bi report
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 calculate...
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?
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