DAX Help - windowing function

[kamakay]

Dear All,

I would like to compute for a table the equivalent of the SQL windowing function

SELECT url, date, status, count(*) over (partition by url) as UrlCount FROM logs

My target is to filter from the table all the urls with a limited amount of Hits.

How can I solve this using DAX?

Thanks in advance for any help you can provide me.

Roberto

[v-yulgu-msft]

Hi @kamakay,

Suppose there is a source table containing many columns, and now what you want is select several columns from it into a new table.

Then, please try this formula to create a calculate table:

Table =
ADDCOLUMNS (
    SELECTCOLUMNS (
        'SQL windowing function',
        "url2", 'SQL windowing function'[url],
        "date2", 'SQL windowing function'[date],
        "status2", 'SQL windowing function'[status]
    ),
    "counturl", CALCULATE (
        COUNTAX ( 'SQL windowing function', 'SQL windowing function'[url] ),
        ALLEXCEPT ( 'SQL windowing function', 'SQL windowing function'[url] )
    )
)

Thanks,
Yuliana Gu