Forum Discussion

RobertM's avatar
RobertM
Frequent Visitor
9 years ago
Solved

Hyperlink

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

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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,

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      RobertM
      Frequent Visitor
      9 years ago

      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's avatar
        Anonymous
        Not applicable
        9 years ago

        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,