Adding QTD and YTD to DimDate

[Anonymous]

Hi Experts

How would you add to a dimdate calender table the QTD and YTD columns so when you select either QTD or YTD in a slicer we get the correct sales for that period. i have created the necessary relationship between DimDate and DinSales tables..  

[Greg_Deckler · Accepted solution]

So, without sample data, can only sort of guess, but it should be something like what I have in a bunch of my Quick Measures like Time Intelligence the Hard Way:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

You will also probably want Quarter:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Quarter/m-p/391541

Otherwise, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Thanka greg aleays appreciate the positive feedback

[v-jiascu-msft]

Hi @Anonymous,

It's not a good idea to add the sales amount as columns in the Date table. I would suggest you use measures instead. Please try these DAX functions. totalytd-function-dax, totalqtd-function-dax.

Best Regards,
Dale