Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Mattiar
Helper I
Helper I

Variables in TotalYTD [,YearEndDate]

Hello, everyone,

I'm submitting a problem to you and ask if you have any workarounds.

 

I was simply doing a YTD and wanted it to end at the previous month. I get the result by putting the month value as a string.

 

Since a static value is required, I tried initialising a variable that would get the desired.

As I show you from the pictures, this is currently not possible.


Do you have another way?

 

2024-07-26_12h02_12.png2024-07-26_12h02_48.png

Mattia

 

2 REPLIES 2
MalkhazTsagarel
Regular Visitor

Hello, 
Maybe this will help:
YourMeasure =
VAR LastDayPrevMonth = EOMONTH(TODAY(), -1)
RETURN
TOTALYTD(
[YourExpression],
Data[Date],
LastDayPrevMonth
)

As I wrote above, the problem is precisely that the measure currently does not accept a variable as input even if it is a constant.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors