Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Greetings,
I have following table. i would like to find next date of current date using measure .
I am calculate it using adding new column to table but i don't know how to calculate using mesure
in above figure i have nextdate which is new added column .but i want same output using measure
Solved! Go to Solution.
Regardless of calculated column or measure, the formula does the trick
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
Regardless of calculated column or measure, the formula does the trick
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
@Dangar332 Try:
nextdate =
var currentdate = MAX(stock[date])
return
MINX(FILTER(stock,stock[date]>currentdate),stock[date])
hi, @Greg_Deckler thank for reply
when i use your code in measure and put in table it give nothing(blank)
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
8 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
10 |