Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have a messure
Fees = sumx(filter('FeeTable','FeeTable'[Type]="Personal"),'FeeTable'[Ammt]) /-10
Then I have a Date Table
Has Fiscal Year (Date Data Type) like , Fiscal QTR Num (Whole Number Data Type), Fiscal Monnth (Whole Number Data Type)
2018
2017
2016
Both tables are connected via Month_ID (Which is a text field).
How do I find YTD, QTD, MTD data?
Apprecite your help.
Solved! Go to Solution.
Hi irehman,
DAX has built-in function TOTALQTD, TOTALMTD, TOTALYTD to calculate QTD, MTD, YTD, please refer to: https://msdn.microsoft.com/en-us/query-bi/dax/time-intelligence-functions-dax. For more details about when to use these functions and how to use these functions, please refer to: https://www.mssqltips.com/sqlservertip/4841/calculating-mtd-qtd-ytd-running-and-cumulative-total-in-....
Regards,
Jimmy Tao
Hi irehman,
DAX has built-in function TOTALQTD, TOTALMTD, TOTALYTD to calculate QTD, MTD, YTD, please refer to: https://msdn.microsoft.com/en-us/query-bi/dax/time-intelligence-functions-dax. For more details about when to use these functions and how to use these functions, please refer to: https://www.mssqltips.com/sqlservertip/4841/calculating-mtd-qtd-ytd-running-and-cumulative-total-in-....
Regards,
Jimmy Tao
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |