Pivot Table with last date transactions  [Solved]

Anything related to PowerPivot and DAX Formuale
ricafonyat
Posts: 1
Joined: Sun Oct 08, 2017 3:07 am

Pivot Table with last date transactions

Postby ricafonyat » Tue Nov 28, 2017 1:37 pm

Dear members,
Let me know if you can help me with a solution.
My data model has two tables.
One Date Dimension Table & One transaction table.
Inside the fact table there are many transactions with different dates.
MY goal is to show in a pivot table all the records of the last date transactions.

How can achieve that?

Thanks a lot

MattAllington
Posts: 968
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Pivot Table with last date transactions  [Solved]

Postby MattAllington » Thu Nov 30, 2017 5:22 pm

There are a few ways, but probably the easiest and maybe even most efficient is to add a calculated column to your calendar table something like this. I think this will work

IsLastDate = if(Calendar[Date]) = lastdate(TransactionTable[Date]),TRUE(),FALSE())

You can then filter on this column in your pivot.
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 5 guests