Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi Community,
I have a table where I have few dates associated with an account. I have created a waterfall chart to evaluate the performance
within last two quarters.
I want to create a measure where I want to filter out those accounts where it started within the last quarter.
The measure should take the earliest date among all the dates related with that particular account and
check whether it is within the last quarter or not. If not, it should return 0 for that account.
I have the data as follows.
NOTE: I have few accounts that are blank, but also that has a date.
Feature_1 | Account_Name | Date |
abc | 31-01-2018 | |
bac | AA | 01-01-2018 |
cab | BB | 06-01-2019 |
epo | BB | 07-01-2019 |
pac | CC | 04-10-2020 |
mjh | SP | 05-10-2020 |
Please help with the DAX. Thanks
Hi @Anonymous -
What is your expected result given this data set? It would be easier for us to help if you provided a copy of your report with sensitive data scrubbed out. See How-to-Get-Your-Question-Answered-Quickly for more tips on how best to present your problem in the forums.
David
User | Count |
---|---|
15 | |
13 | |
12 | |
10 | |
10 |
User | Count |
---|---|
19 | |
15 | |
14 | |
11 | |
10 |