Forum Discussion
Helper IHow to load data in a table based on Max date for the first time
Hi,
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:
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
- amitchandak
Super User
Refer the option you have incremental load
https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
d_sandip59Hi,
I want to show data at Table chart, but not to load them in a incremental load way. I think you misunderstood me.
- amitchandak
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
