Forum Discussion

punati33's avatar
punati33
Regular Visitor
6 years ago

Based on selection chart for Month vs YTD

I have a table where my data is based on Month level , for the same i am planning to generate below DashBoard   columns in table #customers Month[MM/DD/YYYY] segment   CurrentMnthCustome...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

It seems that your fact table has a date column (Month[MM/DD/YYYY]) but I am assuming you do not have a date table in your model.

By adding a date table and creating a relationship to your fact table on the date column, you will be able to use time intelligence functions for things like year-to-date.

Let me know if this helps?

Thanks