Hyperlink

[RobertM]

Hi all,

I'm nearly new to PBI and normaly I'm working with QlikView (worlds between the 2 tools).

Since 2 days I have read solutions in the net, but nothing works 😞 So I ask the community.

I have a problem to find the first- and lastdate in filtered (also with slicer) data.

I have tried FIRSTDATE, MIN, CALCULATE, and so on.

What I get is the first- and lastdate from all data, not from the filtered values!

I have to create a hyperlink (for external report) which have these dates as parameter.

And I also have seen that only a calculated column can be a hyperlink (I wonder why!)

Please help, time is running out.

Greetings from Germany

Robert

[Anonymous]

@RobertM,

Create the following measures using DAX below.

FirstDate = FIRSTDATE(Table12[ChangedDate])
LastDate = LASTDATE(Table12[ChangedDate])

Then create a column using the following formula and check if you get expected result. However we are not able to set web URL for measure, this is expected behavior.

Column = "http://anysite" & "&" & "FromDate=" &[LastDate]& "&" & "ToDate=" & [LastDate]

If the above steps don't help, please elaborate details about your requirement.

Regards,

[RobertM]

Hi

thank you for your reply, but it doesn't work 😞

I have only one table named Calendar:

In the next screen you can also see the measures and calculated column:

But if I select a periode the FirstDate is right, but the LastDate is equal to the FirstDate???

Also see the effect in the grid...

Waiting for response...

Best regards

[Anonymous · Accepted solution]

@RobertM,

Check if the following DAX return your expected result. If not, please post your desired result.

FirstDate = CALCULATE(MIN('calendar'[ReportDate]),ALLEXCEPT('calendar','calendar'[PeriodType]))
LastDate = CALCULATE(MAX('calendar'[ReportDate]),ALLEXCEPT('calendar','calendar'[PeriodType]))

Regards,

[RobertM]

Hi,

this works perfect!

Why must we make such tricks?

Thank you so much.

Regards

Robert