Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
why the calculate function doesn't return any values in the 4th column?
Hi @maciejsok ,
Please consider adding a separate date table to your model for built in time intelligence functions.
https://www.datacamp.com/tutorial/how-to-create-date-tables-in-power-bi-tutorial
@maciejsok Probably because it is a single table model that you are working with. You can do a Previous Month calculation using something like this instead:
Value PM =
VAR __Date = MAX('Table'[Date])
VAR __EndDate = EOMONTH(__Date,-1)
VAR __StartDate = DATE(YEAR(__EndDate),MONTH(__EndDate),1)
VAR __Table = FILTER(ALLSELECTED('Table'),[Date]>=__StartDate && [Date]<=__EndDate)
RETURN
SUMX(__Table,[Value])
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
113 | |
82 | |
45 | |
42 | |
28 |
User | Count |
---|---|
182 | |
83 | |
70 | |
48 | |
45 |