Forum Discussion

gringo89's avatar
gringo89
Helper I
6 years ago

Count step stock at specific date

Hi, Firstly, sorry for my english.   We want to restitute the number of document on each status by date. My fact table likes : users Date event Type event 1 01/03/2020 Sended 1 04/...
Need Help
gringo89's avatar
gringo89
Helper I
6 years ago

Hi v-lid-msft 

 

thanks for you're help.

I think that this approach can resolve my requirement.

 

I use SSAS (2016 version) live connection and i have an error with 'IN DISTINCT' syntax. I don't understand... 

gringo89's avatar
gringo89
Helper I
6 years ago

Hummm.. the 'in' operator is not supported on sql server 2016 (compatibilty tabular 1200) 😞

  • gringo89's avatar
    gringo89
    Helper I
    6 years ago

    Hi All,

     

    Any solution for this requirement ?