Forum Discussion

devika's avatar
devika
Icon for Helper II rankHelper II
3 years ago
Solved

Line graph to stop showing future Quarters

Hi All,   I have connected to Oracle SQL. I used Year and Quarter from the Date hierarchy for the X-axis. I haven't created a separate Date table. There is a data lag in the dataset. As you can see...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    devika , Try like

     

    check =

    VAR MinDate = MinX(allselected(Date), [DATE])
    VAR MaxDate = MaxX(allselected(Date),DATE])
    RETURN
    CALCULATE(IF(MAX([DATE]) < MinDate || MAX([CASE_DATE]) > MaxDate,BLANK(),[answer]) )

  • devika's avatar
    devika
    3 years ago

    Thanks Amit, it works perfectly.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

devika , Try like

 

check =

VAR MinDate = MinX(allselected(Date), [DATE])
VAR MaxDate = MaxX(allselected(Date),DATE])
RETURN
CALCULATE(IF(MAX([DATE]) < MinDate || MAX([CASE_DATE]) > MaxDate,BLANK(),[answer]) )

igonzalezb's avatar
igonzalezb
Icon for Helper I rankHelper I
3 years ago

Hi. This has a side-effect, I believe. If you put this measure in a table visual, the grand total of the year will be blank when we are in the current year. Any way to avoid this? the grand total should be the last nonblank value of the measure.