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.   ...
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,

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,

    • RobertM's avatar
      RobertM
      Frequent Visitor
      9 years ago

      Hi,

      this works perfect!

      Why must we make such tricks?

      Thank you so much.

      Regards

      Robert