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

Transform Quarter Acumlated Values in Month Values

Hi Guys, i have some quarter acumlated values in my table, and i need to see these values in month view!

 

This is the acumulated values that i have:

 

Tab1.PNG

 

 

 

 

 

 

 

 

 

And this is the result that i need... just one column with the non acumulated valuesTab2.PNG

 

 

 

 

 

 

 

 

Doesn't matter if it´ll be with DAX or M... just need this!

 

Someone help me???

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User VII
Super User VII

Re: Transform Quarter Acumlated Values in Month Values

Hey, I tried it and I hope it will work for you:

 

- Add new column for ranking the data

 

Rank = RANKX(Filter(Table1, Table1[Category] = EARLIER(Table1[Category])), Table1[Date],,ASC,Dense)

- Add measure to get the value

 

Cummulative Total Unwind = 
var getPreviousRowRank = FIRSTNONBLANK(Table1[Rank],1) - 1
var getCurrentCategory = MAX(Table1[Category])
var getCurrentRowValue = MAX(Table1[Value])
var getPreviousRowValue = CALCULATE(MAX(Table1[Value]), Filter(ALLSELECTED(Table1), Table1[Category] = getCurrentCategory && Table1[Rank] = getPreviousRowRank))
return if(getPreviousRowValue = BLANK(), getCurrentRowValue, getCurrentRowValue - getPreviousRowValue)

 

Drop a table visual and add following to value:

 

- Date

- Category

- Cummulative Total Unwind (new measure)

 

 

And I guess you will get the data you are looking for

 

PS - Replace table name with your table name in DAX and also replace category with Cod and Value with Valor

 

 






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

1 REPLY 1
Highlighted
Super User VII
Super User VII

Re: Transform Quarter Acumlated Values in Month Values

Hey, I tried it and I hope it will work for you:

 

- Add new column for ranking the data

 

Rank = RANKX(Filter(Table1, Table1[Category] = EARLIER(Table1[Category])), Table1[Date],,ASC,Dense)

- Add measure to get the value

 

Cummulative Total Unwind = 
var getPreviousRowRank = FIRSTNONBLANK(Table1[Rank],1) - 1
var getCurrentCategory = MAX(Table1[Category])
var getCurrentRowValue = MAX(Table1[Value])
var getPreviousRowValue = CALCULATE(MAX(Table1[Value]), Filter(ALLSELECTED(Table1), Table1[Category] = getCurrentCategory && Table1[Rank] = getPreviousRowRank))
return if(getPreviousRowValue = BLANK(), getCurrentRowValue, getCurrentRowValue - getPreviousRowValue)

 

Drop a table visual and add following to value:

 

- Date

- Category

- Cummulative Total Unwind (new measure)

 

 

And I guess you will get the data you are looking for

 

PS - Replace table name with your table name in DAX and also replace category with Cod and Value with Valor

 

 






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors