Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
32 | |
15 | |
14 | |
13 | |
9 |