TotalMTD doesnt work!!!

This is a dedicated forum for people that have questions about the book Supercharge Power BI. In the event of errors in the book, the error information will be in this forum.
carlos barberis
Posts: 2
Joined: Tue Oct 23, 2018 10:20 am

TotalMTD doesnt work!!!

Postby carlos barberis » Tue Oct 23, 2018 11:52 am

Hi friends,
¿is it posible that a PBI function doesnt work?
Attached you will find the exercise of Supercharge Power BI, page 119: Nº 61- [Total Sales Month to Date]
As you can see, figures of Total Sales MTD are equal to Total Sales!!! What I'm doing bad?
The formula used seems OK : Total Sales Month to date = TOTALMTD([Total Sales],'Calendar'[Date])
Thanks in advance
Carlos Barberis
Attachments
TotalMTD.xlsx
(353.57 KiB) Downloaded 5 times

RamanaV
Posts: 22
Joined: Thu Oct 19, 2017 12:57 pm

Re: TotalMTD doesnt work!!!

Postby RamanaV » Wed Oct 24, 2018 10:54 am

Hi,

There is no possibility that a DAX (PBI) function doesn't work.

Your formula is correct.
I think it is a problem with your filters. As I could not understand the language I could not make out what columns you used in filters.

Here is the solution that I got.

Hope it works for you. Otherwise please attach the Power BI workbook. That makes it easy to resolve the issue.

TotalMTD.png
TotalMTD.png (78.03 KiB) Viewed 350 times

carlos barberis
Posts: 2
Joined: Tue Oct 23, 2018 10:20 am

Re: TotalMTD doesnt work!!!

Postby carlos barberis » Sat Oct 27, 2018 9:40 am

Hi RamanaV

Depite the formula was correct, I eliminale it, I writte it again and the problem was solved. I don't know what happened
Very sorry and very thanks
Carlos


Return to “Help with the Book "Supercharge Power BI"”

Who is online

Users browsing this forum: No registered users and 1 guest