Forum Discussion
Post ProdigyFiscal Year - April to March
A column with this cal should allow you to sort perfectly across year and month ranges. The only problem is that the date column of this table will not sort on this. You might have to create a month-Year Col for display
SortCol = CONCATENATE(if([Date].[MonthNo]> 3,DateTable[Date].[Year],DateTable[Date].[Year]-1) ,format(if(DateTable[Date].[MonthNo]> 3,DateTable[Date].[MonthNo]-3,DateTable[Date].[MonthNo]+9),"00"))
Please download the file again from dropbox, which I uploaded. I have corrected fiscal Year cal, created month-year and sort col. Changed the graph and the year filter.
Post ProdigyJust tried to do that, I think I'm doing something wrong. I created a new data table, created a relationship to my main dataset and it's not having it.
This is what it looks like before I create a relationship between the two tables...
And this is what it looks like after
Not sure what I'm doing wrong
I'll add the PBIX file
https://www.dropbox.com/s/y2uggwbh58rvqg2/Disqualified%20Leads%20-%20Test.pbix?dl=0
Cheers
I checked the file and there was no relationship created.
I created it between DateTable.Date and Lead.Month.
Once you do this, you should use date dimensions from DateTable only.
Yo have to do it like this:
- michael_knight
- amitchandak
Super User
I checked the file. The original one. First I created a created_date field by removing the time part and joined it with time. Then I rebuild the chart
Rebuild second chart
- michael_knight
Thanks, amitchandak . Not sure what you mean by this part though
" First I created a created_date field by removing the time part and joined it with time"