Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, PLEASE HELP ME!!!
how can i generate formula to get qty based on issue date based on its delivery date?
i have done formula like below however , it also take value for 10 jan23 delivery date.
var latest_date=MAX('Table1'[Issue date])
return
CALCULATE(SUM('Table1'[Convert qty (kpcs)]),'Table1'[Issue date]=latest_date)
@Izzati_Riza , Not very clear. But if you want both dates to respond to same date filter, you need to have a common date table and join both tables, one join will be inactive, that you can activate using userelationship
example
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
User | Count |
---|---|
77 | |
77 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |