Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear All,
I'm asking for support in calculating aging of items in Power BI. I would like to have 5 categories "0-1 days", "2-7 days", "8-14" days, "15-30 days" and "30 days+". The aging should be calculated against the data in the "Modified" field of my database, and it should exclude the working days. In excel I would create a column for working days with following function: NETWORKDAYS(D2,TODAY())-1 and another column for the aging with following function: IF(I2>30,"30+ days",IF(I2>14,"15-30 days",IF(I2>7,"8-14 days",IF(I2>1,"2-7 days", IF(I2<2,"0-1 days"))))) .
Can you please help me, how to translate this to Power BI, as I'm kind of new to this tool and I still have to learn a lot, but I already would like to transfer some of my daily reports related to my work to power BI.
Thanks in advance!
Kr,
Attila
I have an equivalent for NETWORKDAYS for DAX in the Quick Measure gallery.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/m-p/367362
There is even a version that supports excluding holidays.
Your IF statement should work almost verbatim. You would create a measure for NETWORKDAYS using the formulas provided and then use that measure in place of your cell reference for the number of NETWORKDAYS. Let me know if you need additional guidance.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |