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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.