Forum Discussion

NadaBen's avatar
NadaBen
Helper I
9 years ago

dynamic filter

Hello,

 

I import this table below from BI (Analysis services), this table is huge and i cannot import it entirely, in addition i need restrictred information from it, i want to filter my "snapshot day" to be the recent day available, and the commonperiod.week to get only the 5 first weeks, knowing that when  i try to change the data type for commonperiod to date i have an error because the format "week 19, 2017" is not recognised by PowerBI.

 

 

 

Thanks,

 

Need Help

11 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    Does your cube have a column that's DateTime/Date, or one that can be easily parsed to be DateTime/Date ?

     

    Are you able to add columns to tabes in your cube?

    • NadaBen's avatar
      NadaBen
      Helper I
      9 years ago

      Hi Anonymous,

       

      I read the article and followed the steps, but i don't seem to get the result. Actually, once i create (lastdate) and came back to the dable where i have the column table to do filter on it (date filter equals ), i got a error before changing "lastdate" in the M language.

       

      What do you think is the problem?

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi NadaBen,

         

        Can you please share sample file to test?

         

        Regards,

        Xiaoxin Sheng