Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Folks ,
Pls help me in getting the solution to get the difference of amout with change in dates .
Snip of data :-
Need data like :-
So , as per snip it is clearly visible like with the change in dates , there is only difference amount is showing to next date. It needs to show the movement between each day.
Criteria :
The first date will be full balance (B34-B47 in attachment) – but then every other date should show movement between dates (see C34-C47 in attachment)
kindly help me in getting this solved .
Solved! Go to Solution.
Last Day = CALCULATE([measure], previousday('Date'[Date]))
diff =[This Day] - [Last Day]
This step is working.
Many Thanks
@Sajid02 , Based on what I got, this day vs previous day solution should work
Assume you have measure already
example
This Day = [measure]
This Day = CALCULATE([measure], FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))
Last Day = CALCULATE([measure], FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])-1))
Last Day = CALCULATE([measure], previousday('Date'[Date]))
diff =[This Day] - [Last Day]
Day Intelligence - Last day, last noncontinous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s
Last Day = CALCULATE([measure], previousday('Date'[Date]))
diff =[This Day] - [Last Day]
This step is working.
Many Thanks