Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am currenty brining in monthly EOM snapshots of data into power bi. I want to get to a promotion rate and would like to caputer anyone who was coded to a specific level for all of 2021. So, in January you were coded as M1 but now you are coded as M3, I still want to pull that into my denominator.
any ideas how i can do this? below is my meausre and I bolded out where i am struggling. Its because i am taking the last day of the month LASTDATE('Snapshots'[Data As Of]), but i want to take all month end for the year. any ideas?
@mmills2018 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |