Replacing only function in the chart

[lprasanth]

Hi guys,

    is there any way we can move the following only function to the load  

idDateStkP       date stock projection

       1                               22/8/2018

        2                              23/8/2018

        3                               24/8/2018

        4                                25/8/2018

        5                                  26/8/2018

         6                                 27/8/2018

         7                                 28/8/2018

=only({<idDateStkP={1}>}[date stock projection]) 

I had to use this function for seven times to calculate certain values in the chart which taking to long to load since I have plenty of data. I also understand the fact that we can't write a set expression in the load. I would like to have some alternative examples to do the same thing in the load. can you guys pls help me out...

[pradosh_thakur]

May be this but it will restrict the data in the app level and not chart level
where idDateStkP= 1 ;

[Vegar · Accepted solution]

You could do as @pradosh_thakur are writing with an where clause if you are ok with excluding the other rows.

Another approach is to create another date field in your table, like this:

LOAD
idDateStkP,
[date stock projection],
IF(idDateStkP=1,[date stock projection]) as [Your New Date Field]
FROM
DataSource