Forum Discussion

devika's avatar
devika
Helper 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
Super 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
    Helper 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.