Calculating Quarters

[MissBI_21]

Hi,

I was wondering if anyone could help me. I have the dashboard below:

What I'm trying to do is when QTD is selected along with a specific month, I want to show the months that are in the quarter with the data filled.

The backend table looks like this which already has a column for the quarter:

The calculations for the other functions are below:

1 - Month

2 - YTD

3 - 12 months

4 - Fiscal Year

5 - QTD (not working yet)

Could anyone help me with the syntax to work out QTD please?

[ALLUREAN]

Hi, @MissBI_21 

Please check this sample file:

https://www.dropbox.com/s/twvng51rr5k7me8/DynamicTimePeriods%28allure-analytics.com%29.pbix?dl=0

Take a look how it is working and maybe you will use the workaround there. 

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/

[V-lianl-msft]

Hi @MissBI_21 ,

The picture is not very clear.For such problems, maybe referring to this blog can help you:

https://www.havensconsulting.net/blog-and-media/creating-a-mtd/qtd/ytd-time-intelligence-slicer 

If the problem persists, please refer to this blog to describe your problem:https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 

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

[amitchandak]

@MissBI_21 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

For QTD usually, we use Time intelligence with date table

example

QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))