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.
ID, name, measure 2, measure 3 and indicator are coming from one dataset(having one year of data) , date(xyz date not calendar date) is coming from one dataflow and measure 1 is coming from ssas tabular model(having 5 years of data with same tables).
Can we show data for one year and 5 years in same table visual. If i select one year (e.g current year in date slicer) it should display 5 years of data for measure 1 and one year(current year) data for measure 2, 3
Example as shown below:
What dax calculation should I use for measure1 and how do I relate table(measure 1) with date table.
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 |
---|---|
102 | |
101 | |
78 | |
70 | |
64 |
User | Count |
---|---|
140 | |
106 | |
100 | |
83 | |
73 |