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 August 31st. Request your voucher.
Hi,
I have two data sets, where the main one is refreshed every day and the 2nd one is based on the user's ad hoc intervention. To connect two data sets together I've created Reporting_Date table with distinct reporting_dates. Now I would like to create Manual_Date column where I assigned for each reporting date relavant manual input date. Can you help me with the DAX formula to receive Manual_Date column? Manual Input date should be equal or higher than Reporting_Date but also we should take into account that we need to take the most recent one (if exist)
Thanks
Solved! Go to Solution.
Hi @pbi_rafal ,
From what I can understand the first two table are is your initial input try the following steps:
Power query:
1.
2.
3.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsBrilliant solution! Thanks Miguel!
Hi @pbi_rafal ,
From what I can understand the first two table are is your initial input try the following steps:
Power query:
1.
2.
3.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
77 | |
76 | |
36 | |
31 | |
29 |
User | Count |
---|---|
93 | |
79 | |
57 | |
48 | |
48 |