Forum Discussion

ruyaselman's avatar
ruyaselman
Icon for Helper I rankHelper I
8 years ago
Solved

Latest entry for distinct values in Power BI

I need to get the latest entry for Ontrack for Cumulative column.   I tried get the latest entry by filtering the entries in achievement field by excluding the blank fields however this formula is ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Is this the result you are expecting?  You may download the file from here.  Please note that i have removed the Status column.  You had written a Status calculated column formula which in turn was refering a measure.  A calculated column formula should not refer to a measure.  If the result in the file is correct, then we can talk of the second problem i.e. getting the Status column in the Table with the help of a measure (not a calculated column).

     

ruyaselman's avatar
ruyaselman
Icon for Helper I rankHelper I
8 years ago

Hi Ashish,

 

This is what I was looking for thank you so much..

 

I also find a way to add a new column and switch it to date format. Maybe it will be usefull for end users, I used the following code:

 

Column = SWITCH('KPI'[Month],"January",DATE(2018,01,01),"February",DATE(2018,02,01),"March",DATE(2018,03,01),"April",DATE(2018,04,01),"May",DATE(2018,05,01),"June",DATE(2018,06,01),"July",DATE(2018,07,01),"August",DATE(2018,08,01),"September",DATE(2018,09,01),"October",DATE(2018,10,01),"November",DATE(2018,11,01),"December",DATE(2018,12,01))

 

Many thanks for your support

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

You are welcome.