Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I need to create some Power BI measures for Total Charges and Previous Month Charges however my data for each billing period looks like this:
Dec Billing Period - Start 11/28 - 12/27
Jan Billing Period - Start 12/28 - 1/27
Feb Billing Period - Start: 1/28 - 2/27
Each billing file is being merged into one table with the following column Billing[UsageStartTIme]
Need something dynamic that could be used in different measures etc. Also, how would I use the
Current Period Charges =
Previous Period Charges =
I've read about using time intelligence with filter and min/max but not sure where to start.
You will need to split out your start and stop times, then you could use something like:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
@Greg_Deckler
I do have a beginning and end column in my data table, both examples are good, I'm right now digging into the measure you have in the periodic billing example to see if that would work, I'll let you know.
Another potential solution I had found before was this one but couldn't quite get it to work for me.
https://community.powerbi.com/t5/Desktop/Using-non-month-end-relative-date/td-p/289048
Thanks for responding.
What I ended up doing was using the billing period column I had created (201912, 201901, 201902) for each billing file, then performed a Rankx on the list and ordered them based on the latest billing period being 1, previous 2 etc.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |