Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |