Writing text near pivot table with dax

[pccamara]

Hi guys

Usualy my reports have always the information of the dates of the report, i mean, between this date and that date.
In excel is pretty easy to do it, but i can't do the same with with dax on my power pivot.
Is there any way of doing it, for example something like this :

="This report is from "&MAX(Purchases[Date])&" till"&MIN(Purchases[Date])

Thank you so much guys
Pedro

[CK76]

Hmm, there really isn't enough detail to give you specifics.

But in general you'd do this in separate pivot table from your data.

Assuming that you want to show first & last date, regardless of filter applied...
lastdate:=MAXX(ALL(Purchases),[Date])
firstdate:=MINX(ALL(Purchases),[Date])
DateRange:="This report is from " & [firstdate] & " till " & [lastdate]

Stick "DateRange" measure into value field.
0.JPG

If it should change with filter (i.e. slicer set up with link), just use MAX() and MIN() respectively.

[pccamara]

Hello CK
Did the same as you, but without the DateRange built, cose i have several tables, but it's a big satisfaction that i came up the same solution. I wish i could, of course after build those measures for each table, do it without have to do a pivot table...or as much as i need.
Just a quik question: what i did is a measure that concatenates the min and the max, for each table, but without the X and the ALL, cose those tables are never filtered. Cose i'm just a beginner in dax, why did you do it with X and ALL?

[CK76]

MAX/MIN is aggregator function and summarizes ALL rows in current filter context.

Where as MAXX/MINX is iterator function and evaluates by iterating over each row in current filter context.

Syntax for MAXX/MINX is Function(Table, Expression).

This allows the function to override filter context of slicers etc.
Hence, I added ALL(Table) to ignore all fiter and evaluate MAXX on entire table.
Resulting in same value returned regardless of slicer selection.

Where as MAX/MIN will change as filter context changes.

If you don't apply filter, then both function will return same result, and MAX/MIN is more efficient as it does not need to iterate over each row.

[pccamara]

Awesome. Thank you so much

[CK76]

You are welcome and thanks for the rep