Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All
I have below YTD expression working fine :-
Hi @admin11
Good day,
Please check this video might help, https://youtu.be/WiuXJGWwong
Thanks & Regards,
Mohammed Adnan
https://www.youtube.com/c/taik18
i Just finish watching the youtube.
I try to change the Y to M :-
HI @admin11
Try this 2 formulas..
TOTALMTD(GL[AMOUNT], 'DATE'[DATE], ALL('DATE'[DATE]), GL[1_EXP] ="EXP")
TOTALYTD(GL[AMOUNT], 'DATE'[DATE], ALL('DATE'[DATE]), GL[1_EXP] ="EXP", "02/28")
Thanks & Regards,
Mohammed Adnan
Thank you for your sharing .
The first expression , i get error msg :-
Too many arguments were passed to the TOTALYTD function. The maximum argument count for the function is 4.
the second expression , i get error msg :-
Too many arguments were passed to the TOTALYTD function. The maximum argument count for the function is 4.
Paul Yeo
hi @admin11
Can you share the pbix file..
Thanks & Regards,
Mohammed Adnan
Hi @admin11 ,
Your formula is used to calculate YTD. If you want to calculate the value of February, it is recommended that you apply filters to [amount].
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for sharing.
The reasons i need it with out using filter panel is because , i need it dynamic change every month with me change the filter panel setting.
Paul
Hi @admin11 ,
Do you want to display the sum of the most recent months in the fact table with a card?
Try this measure:
Measure = var min_ = CALCULATE(MAX(GL[Posting Date]),ALLSELECTED('Date'))
var ym = FORMAT(min_,"YYYY-MM")
return CALCULATE(GL[AMOUNT],FILTER(GL,GL[1_EXP]="EXP"),FILTER('Date','Date'[YrMth Sort]=ym))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much for your sharing. it work fine on the simple file , But when i try to test with my raw data , i notice that it does not work. it display blank , Hope you can take a look.
Above is my PBI file
Paul