Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
neil37
Advocate I
Advocate I

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 help or assitance is greatly appreciated. Anything bolded is the column name in our dataset. Anything underlined denotes the table. The tables and columns would be indicated in DAX like: (e.g., 'table' and [column] would come from this: 'wa offense'[caseno]

 

SELECT date_format(occuron, '%Y') AS occuronyear, count(DISTINCT caseno) AS dis_caseno FROM wa offense GROUP BY date_format(occuron, '%Y')
____________________
Specfic ibroff category:
 
SELECT date_format(occuron, '%Y') AS occuronyear, count(DISTINCT caseno) AS dis_caseno, ibroff
FROM wa offense
GROUP BY date_format(occuron, '%Y'), ibroff
 
 
Alternatively, is there a way to utilize python instead of DAX? Thank you!
1 REPLY 1
rfigtree
Resolver III
Resolver III

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]
              )

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.