Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to load table data by Max date by default and will changes accordingly by user's date selection

Hi, amitchandak Greg_Deckler ImkeF parry2k I have a table with load date and the requirement is to load data by max load date when it will load for the first time, but there is also a Filter drop d...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi,

    I have solved it by below measure:


    Load Date =
    var vMaxLoadDate = IF(ISFILTERED(EDG_COUNT_STATUS[Date]),SELECTEDVALUE(EDG_COUNT_STATUS[Date]), CALCULATE ( MAX ( EDG_COUNT_STATUS[Date] ), ALL ( 'EDG_COUNT_STATUS' ) ))
    //var vMaxLoadDate = CALCULATE ( MAX ( EDG_COUNT_STATUS[Date] ), ALL ( 'EDG_COUNT_STATUS' ) ))
    //IF( MIN(EDG_COUNT_STATUS[Date]) = vMaxLoadDate ,1,0)
    return vMaxLoadDate

     

    and use 'Load Date' as measure column in the table , but you need to uncheck the 'Totals', as 'Load Date' is a measure, and it will show selected date in totals.

    but you can't select more than one Date value from Date filter dropdown.

     

    and it works well for me.

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

what is measure here?

Measure 2 =
var vMaxLoadDate = CALCULATE ( MAX ( EDG_COUNT_STATUS[Date] ), ALL ( 'EDG_COUNT_STATUS' ) )
return
if(isfiltered('Data'[Date]),
calculate([measure],filter(EDG_COUNT_STATUS,EDG_COUNT_STATUS[Date]=vMaxLoadDate)),
calculate([measure])
)

I dont understand. Please explain your thout about it.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

Can any one suggest that how can we achieve this thing: How to load table data by Max date by default and will changes accordingly by user's date select

 

please give me an idea about it.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

    I have solved it by below measure:


    Load Date =
    var vMaxLoadDate = IF(ISFILTERED(EDG_COUNT_STATUS[Date]),SELECTEDVALUE(EDG_COUNT_STATUS[Date]), CALCULATE ( MAX ( EDG_COUNT_STATUS[Date] ), ALL ( 'EDG_COUNT_STATUS' ) ))
    //var vMaxLoadDate = CALCULATE ( MAX ( EDG_COUNT_STATUS[Date] ), ALL ( 'EDG_COUNT_STATUS' ) ))
    //IF( MIN(EDG_COUNT_STATUS[Date]) = vMaxLoadDate ,1,0)
    return vMaxLoadDate

     

    and use 'Load Date' as measure column in the table , but you need to uncheck the 'Totals', as 'Load Date' is a measure, and it will show selected date in totals.

    but you can't select more than one Date value from Date filter dropdown.

     

    and it works well for me.