Forum Discussion

DryMouse555's avatar
DryMouse555
Frequent Visitor
2 years ago
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...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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

     

  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    "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 

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

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's avatar
DryMouse555
Frequent Visitor
2 years ago

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's avatar
    Ritaf1983
    Super User
    2 years ago

    "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