Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi I have a problem with creating the measure 'sum value last month'.
really need your help!
cross filter direction
if i SET data model with single relation, ---the ADDDATE not working
if I set data model with bi-relation, ---system not output results
I create a 'calendar' table called 'calendar' having filed called (Dates) use DAX based on my un-continues date in the main table called 'fdate', which only has 1 day per month.
@Anonymous ,
Have marked Calendar as date column. This will check all dates are continuous
Hope you created Calendar using Calendar function not distinct of date from tables
hi, sorry, I am not sure how to 'marked Calendar as date column' any suggestion?
I use this DAX created my 'Calendar' table.
Calendar =
VAR Days = CALENDAR (DATE ( YEAR(MIN(kicksall[fdate])) ;1 ;1 ); DATE(YEAR(MAX(kicksall[fdate]));12 ;31 ) )
RETURN ADDCOLUMNS (
Days;
"Year"; YEAR ( [Date] );
"Month Number"; MONTH ( [Date] );
"Month"; FORMAT ( [Date]; "mmmm" );
"Year Month Number"; YEAR ( [Date] ) * 12 + MONTH ( [Date] )- 1;
"Year Month"; FORMAT ( [Date]; "mmm yy" );
"Quarter"; FORMAT ( [Date]; "\Qq");
"Year Quarter"; FORMAT ( [Date]; "yyyy \Qq" )
)
so if I do not have the bi-relationship, calender date itself is continues
User | Count |
---|---|
73 | |
70 | |
38 | |
24 | |
23 |
User | Count |
---|---|
96 | |
93 | |
50 | |
41 | |
40 |