CODEWITHSUNDEEP
powerbidaxpowerbi-desktop
Francesco Mantovani
Francesco Mantovani

Reputation: 12327

Power BI :: Compare DATESMTD with previous month DATESMTD

I created a MTD measure:

MTD = CALCULATE(SUM(Data[Cost]),DATESMTD('Calendar'[Date].[Date]))

and a previous month MTD measure:

SPLM = CALCULATE([MTD], DATEADD('Calendar'[Date].[Date], -1, MONTH))

Following this guide.

The problem is that the line chart is acting weird and the two Cards that are supposed to show the numbers are (Blank) .

enter image description here

Here the:

Where am I wrong?

Upvotes: 2

Views: 481

Answers (1)

user1874594
user1874594

Reputation: 2493

It seems like you are trying to create a Month-to-Date (MTD) measure and a previous month MTD measure in Power BI, but the line chart is not behaving as expected and the two cards are showing (Blank).

One possible reason for this issue could be that the data in the Data[Cost] column is not being recognized as a numerical value. You can try changing the datatype of the Data[Cost] column to a numerical value (e.g. decimal number) and see if that resolves the issue.

Another possible reason could be that there is an issue with the relationship between the Data and Calendar tables. You can check if there is an active relationship between these two tables and if the relationship is set up correctly.

Upvotes: 0

Related Questions