Forum Discussion
Help: Fixed LOD in Power BI
Hello, anyone can help do the level of detail type of calculation in power bi?
I have two extract in Power BI, and i need to get the Fiscal Year for a specific Project Number based from which: "Previous Week" extract and the "Current Week" extract.
How do i implement the formula below in Power BI?
{ FIXED [Project Number1]: MIN(if [Week]="Current Week" then [Fiscal Year] end)}
{ FIXED [Project Number1]: MIN(if [Week]="Previous Week" then [Fiscal Year] end)}
Your help will be appreciated.
3 Replies
- amitchandak
Super User
Anonymous , need to know you table structure
calculate(min(Table[Fiscal Year]), filter(allselected(Table),Table[Week]="Current Week" && Table[Project] =max(Table[Project])))
calculate(min(Table[Fiscal Year]), filter(allselected(Table),Table[Week]="Last Week" && Table[Project] =max(Table[Project])))
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
v-yalanwu-msftCommunity Support
Hi, Anonymous ;
Not very clear about your logic, can you share more details and logic about your problem? Or share pbix that removes sensitive data.
Hello, i have created a new post about this, kindly check the updated one please.
https://community.powerbi.com/t5/Desktop/Fixed-LOD-in-Power-BI/m-p/1932224
