Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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,
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,
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
@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,
Hi,
this works perfect!
Why must we make such tricks?
Thank you so much.
Regards
Robert
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |