The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Looking to create two new columns that then give the difference between two columns, for example
different between 2021/22_22 count and 2021/2_P11 Count and then the same for mins.
Hi @Anonymous ,
There's no 2021/22_22 column in your sample, is it a column in the same table with 2021/22_P11? could you please explain it more?
Best Regards,
Community Support Team _ kalyj
@Anonymous , Do you have custom period and you want period over period time intellignece
if these are standard month
Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA
for custom period jump to custom section
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs
User | Count |
---|---|
69 | |
68 | |
64 | |
54 | |
28 |
User | Count |
---|---|
112 | |
81 | |
65 | |
48 | |
43 |