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: 931
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".
https://exceleratorbi.com.au/power-bi-online-training/


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 2 guests

cron