Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Overlapping Date Range Puzzle

Hi,   I wonder is anyone could help with this Power BI / DAX puzzle that has been causing my brain to do back flips over the past couple of days?   I'm trying to determine the number (COUNT) of s...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    I think I see. You could maybe add another couple of columns to your date table, one with the month name and one with a sort order that returns 1 for July, 2 for August through to 12 for June. sort the new month name column by that sort order column and use it on your visual

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks. I've already got the MonthYear part sorted by Application cycle (see below) but I was really looking to layer these on top of one another so that the x-axis covers two years (July to July + 2 Years) rather than being one continuous line, if you see what I mean.

 

 

Best Regards

 

John

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    4 years ago

    I think I see. You could maybe add another couple of columns to your date table, one with the month name and one with a sort order that returns 1 for July, 2 for August through to 12 for June. sort the new month name column by that sort order column and use it on your visual