Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have created MTD,YTD,QTD values.i have created table with mentioned values.when i select single month values are matching but when i select multiple months ex: january,february,march the values are going to display for march only not for sum of January,february,march.Please help me.
Hi @adityapv ,
Not certain what is your expected output. When I create these measures in my side, the total value is correct:
Could you please consider more details about this issue like screenshots, sample file without sesentive information or expected output for further discussion?
Best Regards,
Community Support Team _ Yingjie Li
Hi amit,
thanks for the reply.I have used same formulas while calulating mtd and ytd values.but when i select multiple months lets say january and february then instead of sum,i am getting only february values.please helpme out.
@adityapv , values will be displayed based on first or last date based on time intelligence function you used .
this will give three months
Sales = SUM(Sales[Sales Amount])
these will be based on march
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
refer video 3,4,5 of this series
https://www.youtube.com/watch?v=OBf0rjpp5Hw&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=3
Hi amit,
i am using matrix table now.I have selected jan,feb,march,as per selection data is displaying correctly but in the matrix total column its not displaying total sum its displaying only mar value.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |