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 need dax expression to rename the below table
MonthYear
July 2017
July 2018
I want to rename July 2017 to YTD 2017 and July 2018 to YTD 2018 to use it on my matrix table.
How can l achieve this in Power BI
Just create a measure called YTD 2017 and have it reference the July 2017 data. Or rename the column manually, or rename it in Power Query, which can change columns.
DAX functions are like Excel functions in that they cannot actually change data, but just calculate it and return results.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi Ed,
Thanks for your responding, can you show an example of the referencing with the measure.
Thanks
Probably = SUM(tablename[July 2017]) or =SUM(July 2017) if it is a measure itself.
If that isn't right, post sample data so we can see what the underlying data looks like and how July 2017 is being arrived at.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering 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 |
---|---|
111 | |
96 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |