Forum Discussion

d_sandip59's avatar
d_sandip59
Icon for Helper I rankHelper I
6 years ago
Solved

How to load data in a table based on Max date for the first time

Hi, I want to load data in a table based on Max date for the first time when the report will load, but if user choose another date from date slicer it will load data accordingly. So if user deselect...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi d_sandip59 ,

    Based on your previously measure, you can create a new table to extract date first:

    Table = DISTINCT('EDG_COUNT_STATUS'[Date])

    Then try to create this measure:

    Date filter = 
VAR _date =
    SELECTEDVALUE ( EDG_COUNT_STATUS[Date] )
RETURN
    IF (
        NOT ( ISFILTERED ( 'Table'[Date] ) ),
        [MaxDateFilter],
        IF ( _date IN FILTERS ( 'Table'[Date] ), 1, 0 )
    )

     You can put this measure in the visual filter of table to solve this case:

    default date valueafter choosing date manually

    Here is the demo, please try it:

    PBIX 

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

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

There are a few ways. Create your calendar table till the max date. And the filter for day .

Create a filter of yes and no in the calendar table based on max date of data and use that filter

Or create a measure like this

Measure =
var _min = maxx(Table,table[date])
return
calculate(count(Table[ID]), filter(table,table[Due_dates]=_max))

Refer

https://www.youtube.com/watch?v=c_MjL1Cngbs

d_sandip59's avatar
d_sandip59
Icon for Helper I rankHelper I
6 years ago

Hi,

I am working on the issue and have create a calculated column on the below dax:

MaxDateFilter = 

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

and make MaxDateFilter =1 only.

but doing that it only loads data based on max date only at the table. But now if I choose different date from the filter it does not load data at the table based on the selected date.

 

So any suggestion on that?

 

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi d_sandip59 ,

    Based on your previously measure, you can create a new table to extract date first:

    Table = DISTINCT('EDG_COUNT_STATUS'[Date])

    Then try to create this measure:

    Date filter = 
VAR _date =
    SELECTEDVALUE ( EDG_COUNT_STATUS[Date] )
RETURN
    IF (
        NOT ( ISFILTERED ( 'Table'[Date] ) ),
        [MaxDateFilter],
        IF ( _date IN FILTERS ( 'Table'[Date] ), 1, 0 )
    )

     You can put this measure in the visual filter of table to solve this case:

    default date valueafter choosing date manually

    Here is the demo, please try it:

    PBIX 

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

    • d_sandip59's avatar
      d_sandip59
      Icon for Helper I rankHelper I
      6 years ago

      Hi,

      Thank you very much for your help. It really wroks.

       

      Thanks,

      Sandip

      • v-yingjl's avatar
        v-yingjl
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi,

        My pleasure🙂

         

        Best Regards,

        Yingjie Li