Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I need a Ageing calculated column when the entry row is blank.
if row is blank of entry date side then give number of missing days
as I am trying to show row which don’t have data only
columns till pu_no are master data columns, from column Entry_date to PuNo are readings data
datediff between Entry_date previous row and calendar date current row might work
as it needs to reset once data comes in
Calendar date | id | T_no | pu_no | entry_date | SL | id | S Name | OBBB | Pr Name | PuNo | Ageing |
16/6/2024 | 10023 | 1 | 17 | 16/6/2024 | aaa | 10023 | site1 | er56 | material1 | 17 | 0 |
17/6/2024 | 10023 | 1 | 17 | 1 | |||||||
18/6/2024 | 10023 | 1 | 17 | 2 | |||||||
19/6/2024 | 10023 | 1 | 17 | 19/6/2024 | aaa | 10023 | site1 | er56 | material1 | 17 | 0 |
20/6/2024 | 10023 | 1 | 17 | 1 | |||||||
21/6/2024 | 10023 | 1 | 17 | 21/6/2024 | aaa | 10023 | site1 | er56 | material1 | 17 | 0 |
22/6/2024 | 10023 | 1 | 17 | 22/6/2024 | aaa | 10023 | site1 | er56 | material1 | 17 | 0 |
23/6/2024 | 10023 | 1 | 17 | 1 | |||||||
24/6/2024 | 10023 | 1 | 17 | 24/6/2024 | aaa | 10023 | site1 | er56 | material1 | 17 |
0 |
Any Help would be Appreciated.
@
Solved! Go to Solution.
Hi @talkprem ,
We have used below DAX expression and getting the aging column as 0,1,2 based on the number of days difference from Entry date.
Let us know if we are missing anything in the requirement.
Thanks!
Hi @talkprem
You can use below DAX query to create calculated column "Aging",
Thanks!
I tried but for me it gave outplut like this
Hi @SamInogic Thanks for helping out but i am getting this output in my data.
there are few id columns which may need to added in the && clause. would EARLIER help?
If there was a way to get the last date of entry at the same row of calendar date the it would have helped on the solution.
there are s_id,T_id,P_id, date fields so the calculation should refresh at each new id fields.
the combination of these are unique.
Thank you in advance. and much respect for helping out.
Hi @talkprem ,
Just to confirm, do you changed the table name and column name as per your data structure. The issue shown in screenshot is due to mismatch of table name and column name.
Yes I have modified it as per my data structure, Please help
Hi @talkprem ,
We have used below DAX expression and getting the aging column as 0,1,2 based on the number of days difference from Entry date.
Let us know if we are missing anything in the requirement.
Thanks!
The previous logic gave some aging increments but the 2nd one is giving 0 in my dataset.
Thanks @SamInogic for helping me ,
I Tried this solution but this does not calculate the actual gap between the entrydate and calendar date, this only shows 1 for each missing entry row. instead of showing 1 and 2 between 16/6 to 18/6 this is showing 1 and 1 for 16/6 to 18/6
can you please help me? maybe earlier function might be needed but i am unable to work it out.
Hi @talkprem ,
Then below DAX expression might help you to get the expected result,
Thanks!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
15 | |
11 | |
7 |
User | Count |
---|---|
25 | |
24 | |
12 | |
12 | |
11 |