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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Cyberflore
Regular 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!

 

 

1 ACCEPTED SOLUTION
Cyberflore
Regular 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

2 REPLIES 2
Cyberflore
Regular 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

 


 

HI @Cyberflore,

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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