March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi guys,
I have a date table being constructed like:
Date =
ADDCOLUMNS (
CALENDAR (DATE(2017;5;1); TODAY());
"DateAsInteger"; FORMAT ( [Date]; "YYYYMMDD" );
"Year"; YEAR ( [Date] );
"Monthnumber"; FORMAT ( [Date]; "MM" );
"YearMonthnumber"; FORMAT ( [Date]; "YYYY/MM" );
"YearMonthShort"; FORMAT ( [Date]; "YYYY/mmm" );
"MonthNameShort"; FORMAT ( [Date]; "mmm" );
"MonthNameLong"; FORMAT ( [Date]; "mmmm" );
"DayOfWeekNumber"; WEEKDAY ( [Date] );
"DayOfWeek"; FORMAT ( [Date]; "dddd" );
"DayOfWeekShort"; FORMAT ( [Date]; "ddd" );
"Quarter"; "Q" & FORMAT ( [Date]; "Q" );
"YearQuarter"; FORMAT ( [Date]; "YYYY" ) & "/Q" & FORMAT ( [Date]; "Q" );
"DaysOld"; VALUE(TODAY() - [Date]);
)
I'd like to add a column with 1 (true) or 0 (false) identifying the date as the most recent (MAX). Looks simple, but I cant get it right...
Thanks!
Solved! Go to Solution.
Not really 😞
09/11/2017 🙂
DD/MM/YYYY
I had to alter the filter, but I'm getting an error. Any idea? 🙂
I want to get the last day when SO is Android. 🙂
LastDayAndroid = IF('Date'[Date] = Max('Stores'[Date]) && 'Stores'[OS] = 'Android';1;0)
Hi, try with:
LD = If(Store[Date]=Max('Date'[Date]) && Store[Store]="Android";1;0)
Regards
Victor
It says something about not being able to get a unique result
Nope. It looks like it can't get an unique value
@Vvelarde i'm trying to resolve on the Stores table with M function. Any idea how to solde the error:
Expression.Error: Não é possível converter o valor #date(2017, 8, 😎 para o tipo List.
Detalhes:
Value=08/08/2017
Type=Type
if [Date] = List.Max([Date]) && [OS] = "Android" then 1 else 0
The quick way is share a file without confidential data.
you can share here or by Private Message.
Regards
Victor
Thanks for being awsome! 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
92 | |
91 | |
79 | |
49 |
User | Count |
---|---|
160 | |
144 | |
103 | |
72 | |
55 |