Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |