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,

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