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 September 15. Request your voucher.

Reply
Cyberflor
Frequent Visitor

Modify DAX function in semantic model

Hello community!

 

I hope that someone can help me to resolve this issue that I'm facing. It seems very easy, but I'm not eable to resolve it.

 

Well, the problem  is the update of the new year in the power bi reports. The data is located on the sharepoint and can see the reports on the workscpace (Screenshot1)1.png

 

I duplicated the original report S to the C one. And I'm tryinf to download it, because I ca'nt edit the DAX or the functions in the "server" reports. There is no option to export in .pbix format and if I make a save as I cannot open it locally as it is saved in the workspace (screenshot 2).2.png

 

The second problem is that I have used a copy that I have locally to edit the function but I can't replicate the same function in the original report I created a new measurement but I can't configure it as a sum like this:  

Cyberflore_0-1737102381930.png

 

 

In brief, what I want to do is very easy.  I want to correct the function that is incorrectly filtering the year field. But I have not been able to download the report to edit it locally and republish it. 

 

If anyone can help me with this or if there is another way to solve it, I will be very grateful to receive your help.

 

Thank you in advance!

 

 

2 ACCEPTED SOLUTIONS
Cyberflor
Frequent Visitor

UPDATE post !!!!!

I have managed to enter the data model, and I can edit the DAX function. but It still doesn't update!!

My goal is to show the last 5 years in the report. But I don't know why it doesn't update to the current year.

 

This is the function and the model:

Cyberflore_1-1737113480058.png

 

Thank you for any suggestions 🙂

 

P.D.: In case it helps anyone who is confused like me, in order to access the data model you have to activate the option. And it is managed by the admin of the space

Cyberflore_0-1737114103674.png

 


 

View solution in original post

Anonymous
Not applicable

HI @Cyberflor,

It looks like you have found a solution. Could you please mark this helpful post as “Answered”?

 

This will help others in the community to easily find a solution if they are experiencing the same problem as you.

 

Thank you for your cooperation!

 

 

 

View solution in original post

2 REPLIES 2
Cyberflor
Frequent Visitor

UPDATE post !!!!!

I have managed to enter the data model, and I can edit the DAX function. but It still doesn't update!!

My goal is to show the last 5 years in the report. But I don't know why it doesn't update to the current year.

 

This is the function and the model:

Cyberflore_1-1737113480058.png

 

Thank you for any suggestions 🙂

 

P.D.: In case it helps anyone who is confused like me, in order to access the data model you have to activate the option. And it is managed by the admin of the space

Cyberflore_0-1737114103674.png

 


 

Anonymous
Not applicable

HI @Cyberflor,

It looks like you have found a solution. Could you please mark this helpful post as “Answered”?

 

This will help others in the community to easily find a solution if they are experiencing the same problem as you.

 

Thank you for your cooperation!

 

 

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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