Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All
Below expression working fine , now it will display Last YTD full amount :-
Solved! Go to Solution.
Hi,
This measure works
_LYTD EXP 1 = CALCULATE([AMOUNT],GL[1_EXP]="EXP",DATESBETWEEN('Date'[Date],date(year(today())-1,1,1),eomonth(today(),-13)+1))
Hope this helps.
Hi,
Try this measure
=calculate([Amount],datesbetween('Date'[Date],edate(eomonth(today(),-1),-12),eomonth(today(),-1))
I have assumed that amount is a measure. This measure will calculate the amount for the 12 months ended the last day of the current month less 1. So if today is March 12, 2021, the last day of the current month less 1 will be February 28, 2021. The time period will be March 1, 2020 to February 28, 2021.
Hope this helps.
Thank you for sharing .
Actually i have below expression working fine :-
Hi,
This measure works
_LYTD EXP 1 = CALCULATE([AMOUNT],GL[1_EXP]="EXP",DATESBETWEEN('Date'[Date],date(year(today())-1,1,1),eomonth(today(),-13)+1))
Hope this helps.
You are welcome.
User | Count |
---|---|
86 | |
82 | |
68 | |
65 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |