Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
Hi @Anonymous ,
Has your problem been solved?
Please refer to my .pbix file.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You should create relationship between the two tables. Please refer to my .pbix file.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for this solution, but my date table (which is used to calculate date measures) is in this format:
Period Start Date End Date
Last Week 13th July,2020 19th July,2020
Last Month 1st Jun,2020 30th Jun,2020
There is no date column which can be used to create direct relationship between this and the dynamic table.
While you can make a dynamic table inside a measure, the Calendar table in your model is not dynamic. It only refreshes when you refresh the data model (not with slicer selections). Also, why not use CALENDAR(MIN(Table[DateColumn]), MAX(Table[SameorDifferentDateColumn])) ?
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hey @Anonymous ,
I guess it's not possible what you are going to achieve. This is because virtual tables (tables based on DAX) will only be calculated if the data model is refreshed, or when a DAX statement is changed.
For this reason, a virtual table will not be recalculated when a user changes the selection of a slicer.
Can you please describe in more detail what you are going to achieve, maybe then we can come up with a different approach.
Regards,
Tom
Hi @TomMartens ,
Here are my tables:
Table1:
Period Start Date End_Date
Last Week 13th July,2020 19th July,2020
Last Month 1st Jun ,2020 30th Jun ,2020
Table2: KPI table
Date KPI volume
1st Jan,2020 xxx
2nd Jan,2020 xxx
.
.
20th July,2020 xxx
I'm looking to create a line trend graph (date vs kpi) for the date period i choose from the dropdown filter. If the filter choice is "Last Week", then the graph shoud be for 13-19 july.
Is there any other way to do this other than creating a dynamic table?
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |