DAX Measures for Date while using Power BI Dataset
Hi, I am fairly new to Power BI. I am using a dataset (Power BI dataset) as the source for my new report. I am trying to create a new measure using data calculations. Essentially, I have a column [Partner Deal Created Date] with date values: yyyy-mm-dd I would like to add a measure column next to it with the previous month value (integer). Example ideal output: Partner Deal Created Date previousMonth 2021-07-30 6 2021-06-30 5 2021-05-30 4 However whenever I try to perform a PREVIOUSMONTH (or just about any Date calculation for a measure), I get the following error when I add the measure to a table. Formula: previousMonth = PREVIOUSMONTH('xxxxxxxxx xxxxxxxxxx'[Partner Deal Created Date]) Is this a limitation of using a Power BI dataset as the source or can this be achieved using a different formula? My end goal is the be able to have a Measure as part of a slicer (which does not seem possible - I cannot add measures to slicers). Thanks in advance!
