timestamp

2 Topics

Calculate the Second To Last Date But Remove The Timestamp? (CALCULATE & FORMAT?) - CARD
I have this: CalcLastWeek = VAR GetDate = CALCULATE( MAXX ('MyTable','MyTable'[Report Date]), ALLSELECTED('MyTable') ) RETURN CALCULATE( MAXX('MyTable','MyTable'[Report Date]), FILTER(ALL('MyTable'),'MyTable'[Report Date]< GetDate) ) Which does the job, but I need to remove the timestamp that is also displayed on the card. I can't seem to find the correct place to put the FORMAT code. Any help would be greatly appreciated. Thanks.
Solved
Anonymous
4 years ago Place DAX Commands and Tips
1.1KViews
0likes
2Comments
WTD, MTD, YTD working hours of each employee with different timestamps for each day using DAX
This is a sample data. I need to calculate working hours in DAX. Working hours for one day = Last Timestamp of the day - First Timestamp of the day It is easy to calculate for one day but I can't seem to figure out how to calculate total working hours WTD, MTD, YTD. Every day timestamps are different and we want working hours for each Worker(Name) separately. Please guide. I can share the actual data as well if anybody requires. amitchandak Anonymous Jihwan_Kim daxer-almighty PaulOlding Fowmy
Solved
manuvats
5 years ago Place DAX Commands and Tips
2.4KViews
0likes
7Comments