Getting the last date

Advertisement
Hello,
I need to be able to show the last date's value for all dates where a fact measure exists.
For example, let's say I have the following fact table:
Date                  Value
01/01/2000       1
01/02/2000       3
01/03/2000       2
01/05/2000       7
What I need is to have a calculated measure that shows the last entry, so that when I have the pivot table, it looks like this:
Date                  Value  Calculated Measure
01/01/2000       1         7
01/02/2000       3         7
01/03/2000       2         7
01/05/2000       7         7
Advertisement

Replay

Hi Kostaz,
You could try defining a calculated column...I've called this 'Calculated Column' in my example:
=
CALCULATE(
MAX(Data[Value]),
FILTER(
Data,
Data[Date] = MAX(Data[Date])
Then you can use a measure to return the MAX value:
Calculated Measure:=MAX([Calculated Column])
Regards,
Michael
Please remember to mark a post that answers your question as an answer...If a post doesn't answer your question but you've found it helpful, please remember to vote it as helpful :)

How to get the last data point from a TDM file in LabVIEW?

Hello, I am using LabVIEW to analyze some rather large TDM files, and I need a way to get only the last data point.  So far, the only way I have been able to accomplish this is by reading the entire file.  Is there a property in the TDM file or a fun

Getting the last modified date of the contact in addressbook

Hi all, Is there any way to get the last modified date and created date of the contacts stored in address book . I have gone through the api docs and could nt find any api's to get the modified date of the particular contact . Any help would be great

Min,Max for a time Range and Sum of Records for the last date/time

Hi All, I have a table with the following structure/data: create table  Events   (                                     [EventID]        int                   NOT NULL,                                     [Title]             nvarchar(200)  NOT NULL,  

How to get the "last changed by" for a set of function modules?

How to get the "last changed by" for a set of function modules? is there any table to get it??See [this|Re: Date of creation of function module] I posted earlier. >TFDIR will give you the name of the function group program and the include num

How to get the last wbs which is displayed  in transaction code cj03?

Dear Experts,    I want to get the last wbs which are displayed in  transaction code cj03, i have written below program,but i found it is incorrect. because the sort of wbs  in cj03 is not equal to table prps. the last wbs in cj03  is not equal to ta

How to get the last day according to fiscal period input in selection scree

Hello expert how to get the last day of fiscal period input. the fiscal period inculdes 1-16 when fiscal period is greater than 12, only calculate the last day of 12nd month your solution will be apprecaited, FM existing? thank you KevinHi, when you

How do I get the last or maximum value /

Hi all, I got the following query output :- ITEM_______DATE____________PRICE AAA_______01/11/04__________2.5 AAA_______22/04/05__________4.0 BBB_______04/08/05__________44 BBB_______05/08/05__________45 CCC_______04/12/04__________12 CCC_______05/05/

Something about getting the current Date!

I am using this code to get the current DATE ... time=time + new Date().toString(); the out put i get looks like....... Wed july 18 18:37:37 EDT 2001 But i want to include the time in it ,meaning i want the out to look like....... Wed, July 18,2001 i

How can I get the system date in mm/dd/yyyy,

how can I get the system date in mm/dd/yyyy, i need to compare system date with some other date,continuosly using threads,can U plz help me. With Some code Thanks In advnace MahiiiiHi, You can use SimpleDateFormat class under java.text package. Simpl

HOW DO I SEE THE LAST DATE I BACKED UP ON ICLOUD

How can I see the last date that icloud was backed up?Go to Settings>iCloud>Storage & Backup and look at the very bottom under Back Up Now.Read other 2 answers

I need get the last iphone version any person can tell me how i can make it please

i need get the last iphone version any person can tell me how can do it?The iPhone 3G can not run anything higher than 4.2.1. It is obsolete.Read other 2 answers

I have made a burn folder with photos exported from I-photo.  It now shows in information, that the date is created and modified is different from the original digitized date.  How can I get the original date to show in the info from Finder?

I have made a burn folder with photos exported from I-photo.  It now shows in information, that the date  created and modified is different from the original digitized date.  How can I get the original date to show in the info from Finder?The Finder

Getting the last clicked menu item

Hi everybody, Does anyone know if there is a method which exists to get the last item selected from a JMenu? For example, if you click on a menu item called "blah", that method would return that item to you? I looked over the Java tutorial about

How do i get the last 4 chars

String FileE = myFile.getName(); This gives me a file name but how do I a reverse trim and get the last 4 chars??Hi What are you trying to achieve here, why are you pulling a file into a String Buffer ? fileName.getName() will output a string, you ca

How to get the last page  SAP Script form

How to get the last page  SAP Script form. I want to print a specific information in the last page of SAP form (Script). Please tell me how to get the last page number. RegardsHi You have to check the system variable &NEXTPAGE&, if it's 0 it means

Is it possible to view/get the table data from a dump file

I have dmp files generated using expdp on oracle 11g.. expdp_schemas_18MAY2013_1.dmp expdp_schemas_18MAY2013_2.dmp expdp_schemas_18MAY2013_3.dmp Can I use a parameter file given below to get the table data in to the sql file or impdp the only option

How to get the last inserted Autoincrement value in Java for Pervasive DB

Hi, I need to get the last inserted auto incremented value after the record is inserted IN JAVA For ex. consider we have 4 columns for the myTable in the PERVASIVE DATABASE V10 autoid - identity column (auto increment column) userID userName pageID i

How to get the input data on the arbitrary draw event ?

Hi all, I'm trying to draw a histogram on a arbitrary parameter (just like the "Levels" effect). The draw part is well, but I have a problem with the input layer data (param[0]). All I have to do now is read the input data on the arbitrary draw

Can I get a query to get the output data like 4th column instead of 3rd col

Can I get a query to get the output data like 4th column instead of 3rd column ? SQL> select emp.deptno, empno, rownum from emp, dept where emp.deptno=dept.deptno; DEPTNO EMPNO ROWNUM 10 7782 *1* *1* 10 7839 *2* *2* 10 7934 *3* *3* 20 7369 *4* *1* 20