cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
arulsettu Frequent Visitor
Frequent Visitor

Fixed in power bi

HI,

 

   I am very new to power bi. acutally i am trying to convert TABLEAU app into power bi.

 

in a chart there is caluclated dimension created as below

 

{ FIXED [Year Week]: MAX([End Time])}

 

 

Year Week is year and week from a date field

 

so to do this power bi i did as follows

 

Year Week = FORMAT([end_time].[Date],"yyyy")&WEEKNUM([end_time].[Date],2)  ---> in text format

 

And for { FIXED [Year Week]: MAX([End Time])} i did below

 

CALCULATE(MAX([end_time].[Date]),ALL(Year Week))   ---->date format

 

but not getting the output

 

can anyone help me on this

 

6 REPLIES 6
Highlighted
Super User
Super User

Re: Fixed in power bi

I believe what you want is:

 

CALCULATE(MAX([end_time].[Date]),ALLEXCEPT([Year Week])) 

My understanding of FIXED is that it in your case your formula will calculate MAX of [End Time] in the context of [Year Week] regardless of any other dimensions in the view.

 

The equivalent of that should be ALLEXCEPT in that ALLEXCEPT removes all context other than those specified in the function. 


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

arulsettu Frequent Visitor
Frequent Visitor

Re: Fixed in power bi

Thanks for the reply

 

by using this

 

CALCULATE(MAX([end_time].[Date]),ALLEXCEPT('table_name',[Year]))

 

i am getting only one value 

 

31/dec/2016

 

 

and above calcluation i am using as dimension.

 

can you check this

 

 

Thanks

Community Support Team
Community Support Team

Re: Fixed in power bi

Hi @arulsettu,

 

>>i am getting only one value 

If you only drag this measure to a visual, you will get the max date. You can add other columns to work through this issue.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
arulsettu Frequent Visitor
Frequent Visitor

Re: Fixed in power bi

i am using this as dimension

 

CALCULATE(MAX([end_time].[Date]),ALLEXCEPT('table_name',[Year]))

 

and 

 

count(value)

 

so where and what should i add as anew column

 

Community Support Team
Community Support Team

Re: Fixed in power bi

Hi @arulsettu,

 

You should add a index column to let the measure calculate loop the table.

 

For example:

 

Capture.PNGCapture2.PNG

 

Notice: Count(value) will summarize this field

 

Regards,

Xiaoxin sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
arulsettu Frequent Visitor
Frequent Visitor

Re: Fixed in power bi

i am doinglike below is this correct

 

Thanks

Capture.JPG

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 318 members 3,484 guests
Please welcome our newest community members: