Forum Discussion
Precentage difference between the date
- 4 years ago
Fidzi8 , Assume you are using a date table for slicer,
Try measure like
Measure =
VAR _min = MINX(allselected(Dates) ,Dates[Date])
VAR _max = MAXX(allselected(Dates) ,Dates[Date])
return
calculate(sum(Table[cost]), filter(Dates, Dates[Date] =_max)) -calculate(sum(Table[cost]), filter(Dates, Dates[Date] =_min))Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9 - 4 years ago
Hi, Fidzi8
Try this:Measure = VAR _min = MINX( ALLSELECTED( Dates ), Dates[Date] ) VAR _max = MAXX( ALLSELECTED( Dates ), Dates[Date] ) VAR _a = CALCULATE( SUM( Table[cost] ), FILTER( ALL( 'Dates' ), Dates[Date] = _min ) ) VAR _b = CALCULATE( SUM( Table[cost] ), FILTER( ALL( 'Dates' ), Dates[Date] = _max ) ) RETURN DIVIDE( b - a, b )Or, please share your sample pbix file's link here, then I can try to look into it to come up with a more accurate measure.
Best Regards,
Community Support Team _ Zeon ZhengIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Fidzi8 , Assume you are using a date table for slicer,
Try measure like
Measure =
VAR _min = MINX(allselected(Dates) ,Dates[Date])
VAR _max = MAXX(allselected(Dates) ,Dates[Date])
return
calculate(sum(Table[cost]), filter(Dates, Dates[Date] =_max)) -calculate(sum(Table[cost]), filter(Dates, Dates[Date] =_min))
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9
- Fidzi84 years agoHelper V
Hi @amitchandak,
thank you for your help.The formula doesn´t work properly and I don´t know where the error might be.
Thank you
Ondřej