Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have a column named "flag" in which "1" is against billed outlets and "0" is against unbilled outlets. I want to calculate the count of outlets that are unbilled from last 3 Months and exclude the current month.
In full data: year_month range is January 2018 to Decemeber 2020.
In Sample data provided for help: year_month range is 2020.
Attached sample data image. Please guide me in using the DAX expression.
Please provide sample data in usable format (not as a picture) , show the expected outcome, and give sufficient context.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
27 | |
11 | |
8 | |
6 | |
6 |