Best way to create buttons that correspond to specific time periods.

[Anonymous]

Hi BI Community,

I'm creating a dashboard in which I want the user to have the option of clicking one of four buttons - "WTD", "MTD", "QTD", "YTD". Obviously, I want these buttons to correspond to specific windows of time. What's the simplest way to approach this? My source data has sales by day for the past 2 years, and I have a calendar lookup table where I'm mapping the dates to specifc time periods (month, quarter, year, etc.). Keep in mind that I'm working from a fiscal calendar which does NOT correspond to the standard calendar, so that is one complexity.

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

You can refer to this thread:https://community.powerbi.com/t5/Desktop/MTD-QTD-YTD-Calculation/m-p/664067

Best Regards,

Liang

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

[TomMartens]

Hey @Anonymous ,

please provide a pbix that contains sample data but still reflects your data model.

Upload the pbix and/or xlsx to onedrive or dropbox and share the link.

What is the starting month of your fiscal year?

This great article by @GilbertQ explains in great detail what you are looking for.

Regards,

Tom