Forum Discussion

Arjan_w's avatar
Arjan_w
Frequent Visitor
3 years ago
Solved

Getting "First" from column without sorting

I have a big dataset which contains of a couple of columns, but the interesting ones are:  - Datetime (YYYY-MM-DD HH:MM:SS) (every row is approximately 10 seconds apart)  - WeekdayName (Monday/Tues...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    Try

    First Weekday =
SELECTCOLUMNS (
    INDEX ( 1, 'Table', ORDERBY ( 'Table'[Datetime], ASC ) ),
    "@value", 'Table'[Weekday Name]
)
Arjan_w's avatar
Arjan_w
Frequent Visitor
3 years ago

This seems to work good for the start day, thanks!

 

However, when looking at the last weekday (order by descending) the code takes the last day of the slicer +1. Below an example.

 

 

The latest datetime is of the correct date, however the measure doesn't follow this for some reason? 9-6-2023 is a Friday and not a Saturday.

 

The code that I used for the last day:

 

 

Last_Weekday = 
SELECTCOLUMNS (
    INDEX ( 1, 'Table', ORDERBY ( 'Table'[datetime], DESC ) ),
    "@value", 'Table'[weekdayName]
)

 

johnt75's avatar
johnt75
Super User
3 years ago

Check the data in Data view and see what values you have for day of week for that entry. 

  • Arjan_w's avatar
    Arjan_w
    Frequent Visitor
    3 years ago

    I made some mistakes with different column names yes, it was my mistake. Thanks a lot!