Forum Discussion
kkanda
Resolver II
Resolver IITrying to plot previous year's data on the same chart
Hi All, We have a dataset comprising of outage duration for a set of dates. A simplified sample table is given below: OutageDate Mins Equipment Circuit Weather 8/20/2020 235 Cross arm ...
AllisonKennedy
Community Champion
Community ChampionDATEADD function is a good one to use, but it needs to be used with a DimDate table. You must use DimDate[Date] in the DAX, in the visual and in the slicer.
See if this post helps create/explain date tables: https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html
See if this post helps create/explain date tables: https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html
kkandaResolver II
Resolver IIThank you Allison, I have a DimDate file with me. Do I add it to the Relationship table and relate to the Table 1?
And the slicer for Date will be based on DimDate file?
- AllisonKennedyYes, add the DimDate table to the same Power BI report. Create a relationship between DimDate table and the data you're using based on [Outage Date] and DimDate[Date]
Then put the DimDate[Date] in the slicer, in the DAX and in the visualization.