Forum Discussion

neil37's avatar
neil37
Advocate I
5 years ago

Python to DAX Conversion

Hello,    We are trying to convert the following python code into DAX. The goal is to distinct count of case number (caseno) grouped by (year), where occ date/time (occuron) is like YYYY   Any h...
Conversion
DAX
Python
rfigtree's avatar
rfigtree
Resolver III
5 years ago

hi i only know how to write dax within power pivot, but i think you would write something like this.

if it doesnt work the concept is correct, might just need to tweak the syntax to suit your environment.

 

 

evaluate

    summarize(
                addcolumns(table,"Year",format(table[date],"yyyy"),
                [Year],
                [caseno]
              )